Forum Discussion

Kohrinn's avatar
Kohrinn
Icon for Helper I rankHelper I
2 years ago
Solved

Remove one filter in a measure

Hi all,

 

I have a chart like this:

 

 

On every string, there are one or more events. I can click on this chart - both to choose whole string or a single event. I would like to have a measure that will tell me how many events are there on a string, regardless if I click a whole string or a single event. For example, on string 1 I would expect the value to be 6.

I thought it could be like:

 

_howManyCleanings = CALCULATE(
COUNT(TableData[EventID]),
REMOVEFILTERS(TableData[StringID])
)

 

but this is not working - when I click string 1 it shows correctly value 6, but if I click on the event, the measure shows 1, instead of still 6.

How to fix this?

 

Thanks,

Joanna

  • Hi, Kohrinn 

    something like below

     

     

    if yes then try below measure
    adjust table and column name

     

    Measure = 
    CALCULATE(COUNT('Table'[event]),REMOVEFILTERS('Table'[event]))

     

    my data look like below

     

     

3 Replies

      • Dangar332's avatar
        Dangar332
        Icon for Resident Rockstar rankResident Rockstar

        Hi, Kohrinn 

        something like below

         

         

        if yes then try below measure
        adjust table and column name

         

        Measure = 
        CALCULATE(COUNT('Table'[event]),REMOVEFILTERS('Table'[event]))

         

        my data look like below