I'm trying to filter what can be selected in a combo box whose source is a PowerBIIntegration.Data. I've been successful in bring in the Power BI Column of Machine Code and break it down to just Distinct values. I am unsuccessful in doing that and applying a filter from the Powerapps Page (Department_1) to the Power BI column (Dept) to filter the distinct values for a Combo Box source.
Original Successful Items: Distinct(PowerBIIntegration.Data,'Machine Code')
Version I'm working on Items: Filter(Distinct(PowerBIIntegration.Data,'Machine Code'),Department_1.Text in PowerBIIntegration.Data.Dept)
I appreciate any help anyone can give.
Solved! Go to Solution.
I think all you need to do is filter the data first then use the distinct.
Example:
Distinct(Filter(PowerBIIntegration.Data, Department_1.Text in Data.Dept),'Machine Code')
Hi @PaulBI
Distinct always returns a collection with only 1 column called Result
Distinct(PowerBIIntegration.Data,'Machine Code')
will return a collection with column Result that will contain all your distinct machine codes
You will need to update your query accrodingly
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I think all you need to do is filter the data first then use the distinct.
Example:
Distinct(Filter(PowerBIIntegration.Data, Department_1.Text in Data.Dept),'Machine Code')
User | Count |
---|---|
236 | |
112 | |
94 | |
59 | |
31 |
User | Count |
---|---|
289 | |
130 | |
104 | |
62 | |
58 |