Forum Discussion
Summarized slicer
For finishing this post, we need to mark an answer as a sloution.
So here I will copy my answer in Dimensions filtered by summarized measure values and mark it as a solution.
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.
Hi Anonymous - yes I've accepted the solution for : Dimensions filtered by summarized measure values - thank you very much for your help !
For finishing this post, we need to mark an answer as a sloution.
So here I will copy my answer in Dimensions filtered by summarized measure values and mark it as a solution.
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.
Hi Anonymous - sure, thanks that's great