Forum Discussion

richard_wylde's avatar
richard_wylde
Helper IV
6 years ago
Solved

Summarized slicer

In the Slicer Advice it mentions the following limittaions :-    - The numeric range slicer filters every underlying row in the data, not any aggregated value.   Is there a way around this using ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi richard_wylde 

    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. 

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi richard_wylde 

Your problem may have been solved in your new community. Link: Dimensions filtered by summarized measure values

Please kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem or share me with your pbix file from your onedrive business.

 

Best Regards,

Rico Zhou

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi richard_wylde 

    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. 

     

    • richard_wylde's avatar
      richard_wylde
      Helper IV
      6 years ago

      Hi Anonymous  - sure, thanks that's great