Forum Discussion

richard_wylde's avatar
richard_wylde
Helper IV
6 years ago
Solved

Dimensions filtered by summarized measure values

Hello, I have been shown this example   where the value of All Quotes reduces based on Rank By Category. However I need the values of Mar_Desc to disappear rather than reduce in size so in this examp...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi richard_wylde 

    I use measure to achieve your goal.

    Measure1:

    Measure1 = CALCULATE(SUM(Query1[All Quotes]),FILTER(ALL(Query1),Query1[Mar_Desc]=MAX(Query1[Mar_Desc])))

    Measure2:

    Measure2 =

IF( [Measure1]<= MAX(Query1[Rank by category]),[Measure1],BLANK())

    We build a new table visual by Mar_Desc and Measure2. Then select 231830 in Slicer.

    Result is as below:

    You can download the pbix file from this link: Dimensions filtered by summarized measure values

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi richard_wylde 

I use measure to achieve your goal.

Measure1:

Measure1 = CALCULATE(SUM(Query1[All Quotes]),FILTER(ALL(Query1),Query1[Mar_Desc]=MAX(Query1[Mar_Desc])))

Measure2:

Measure2 =

IF( [Measure1]<= MAX(Query1[Rank by category]),[Measure1],BLANK())

We build a new table visual by Mar_Desc and Measure2. Then select 231830 in Slicer.

Result is as below:

You can download the pbix file from this link: Dimensions filtered by summarized measure values

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

richard_wylde's avatar
richard_wylde
Helper IV
6 years ago

Thanks Anonymous  - this works great!

 

Thank you