Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Measure returns 100% after slicing data

Hi all. This one's got me stumped. Following is the dataset that I'm working with (in DirectQuery mode):   I created a couple of measures as below to use in a matrix & a line-chart respectively...
Need Help
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

ALLSELECTED includes the filter on FFF. If you don't want that, then you need a denominator that includes all FFF. I don't know if this is exactly what you want but you can try e.g.

 

var denominator =
    CALCULATE( SUM( 'Tmp'[Amt] ),
        ALL ( 'Tmp'[FFF] ),
        'Tmp'[YYYY_MM] = max_yyyy_mm
    )

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Wow. That did the trick. Thank you so much AlexisOlson ðŸ¤— . But I still can't quite wrap my mind around the logic. If I want the selection in FFF Slicer to affect Line-chart values, shouldn't I use ALLSELECTED() so that it'd consider ALL the datapoints that are selected using different slicers on the page ? And I get that the measure you pasted does work, however, shouldn't ALL() in there, enforce selection of ALL the categories that are available in FFF column. 🤔