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] )
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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] )
)