Further Filters Selections in a Combo Box who's source is PowerBIIntegration.Data

[PaulBI]

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.

[RezaDorrani]

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

[Jeff_Thorpe · Accepted 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')