Forum Discussion

PaulBethancourt's avatar
PaulBethancourt
Frequent Visitor
3 years ago
Solved

Use a Measure as a Slicer

Seems like this should be simple but no.  I wasn't able to apply the suggestions in this forum so I attached a link to a simple Power BI that shows what I'm trying to do. I have a table with Custome...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi PaulBethancourt 

    As you can't use the measure as a slicer you need to add the segmentation as a calculated column.

    From your sample, I understood that this segmentation is on the customer level.
    So you can use dax formula :

    Customers_priority = if (CALCULATE(sum(Data[Amount]),ALLEXCEPT('Data','Data'[Customer]))>=50000,"One",
    if(CALCULATE(sum(Data[Amount]),ALLEXCEPT('Data','Data'[Customer]))>=10000,"Two","Three"))
     

    And then use it on your slicer

     

    Link to your updated file 

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

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

Hi PaulBethancourt 

As you can't use the measure as a slicer you need to add the segmentation as a calculated column.

From your sample, I understood that this segmentation is on the customer level.
So you can use dax formula :

Customers_priority = if (CALCULATE(sum(Data[Amount]),ALLEXCEPT('Data','Data'[Customer]))>=50000,"One",
if(CALCULATE(sum(Data[Amount]),ALLEXCEPT('Data','Data'[Customer]))>=10000,"Two","Three"))
 

And then use it on your slicer

 

Link to your updated file 

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