Forum Discussion

DianaG's avatar
DianaG
Frequent Visitor
8 years ago
Solved

Use aggregated data in slicer

Hi everyone,   I would like to show aggregated data in a slicer, based on the dates, selected in another one.   This is an a example of campaign data, I would like to analyze:     In my ...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    DianaG,

     

    As an alternative, you may use RANKX Function to add a measure and take advantage of Visual level filters.

    Measure =
RANKX (
    ALLSELECTED ( Table1[Campaign] ),
    CALCULATE ( SUM ( Table1[Cost] ) ),
    ,
    ASC,
    DENSE
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

DianaG,

 

As an alternative, you may use RANKX Function to add a measure and take advantage of Visual level filters.

Measure =
RANKX (
    ALLSELECTED ( Table1[Campaign] ),
    CALCULATE ( SUM ( Table1[Cost] ) ),
    ,
    ASC,
    DENSE
)
DianaG's avatar
DianaG
Frequent Visitor
8 years ago

Hi v-chuncz-msft,

thanks for your help! I created a list of data to select and use this one as slicer. However it would be create to be able to use dynamic values. I hope that It will be possible to use a meassure as slicer in the future, because it would be much more flexible.