Forum Discussion

BoNDoK's avatar
BoNDoK
Frequent Visitor
6 years ago
Solved

Use a variable in filter as operand

I have the following tables in Power BI:  FactData Filtering Table I need to create another table programmatically (using DAX) to filter the Fact Table using the selected item from the...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi BoNDoK 

     

    Let me know if you'd like to get below results:

    1. DONOT manage the relationship between them

    2. Add a measure and drag it to the filter pane in FactData table visual, set it as 1

    Measure = IF(SELECTEDVALUE('Filtering Table'[Col1])=MAX(FactData[Cola]),1)

     

    3. final results:

    Pbix attached.

v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi BoNDoK 

 

Let me know if you'd like to get below results:

1. DONOT manage the relationship between them

2. Add a measure and drag it to the filter pane in FactData table visual, set it as 1

Measure = IF(SELECTEDVALUE('Filtering Table'[Col1])=MAX(FactData[Cola]),1)

 

3. final results:

Pbix attached.

BoNDoK's avatar
BoNDoK
Frequent Visitor
6 years ago

Hi Dina Ye,

 

Thanks a lot!!! This is exactly what I wanted to achieve.  But can you please explain to me how this visual level filter is doing this magic? I see it working but I don't understand what is happening behind the scene.

 

Regards,

BoNDoK