Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create Measure Unaffected by Slicer(s)

I have a dataset similar to below. Each row represents an event and the Count column is always populated with a (numeric) 1.   I'm trying to create two measures counting the number of events, one t...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood correctly your question, but please check the below picture and the attached pbix file.

     

     

    first measure: = 
CALCULATE (
    COUNTROWS ( Data ),
    ALLEXCEPT ( Data, Data[EventType], Data[Flag_YN] )
)

     

    second measure: = 
CALCULATE (
    COUNTROWS ( Data ),
    ALLEXCEPT ( Data, Data[Flag_YN] )
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks, not sure what I was doing wrong but creating a new set of measures using those formulas seemed to do the trick.