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 mea...
Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    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

     

     

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, Kohrinn 

try to removefilter with

REMOVEFILTERS(TableData[EventID])

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

I've already tried that, same result.

  • Dangar332's avatar
    Dangar332
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    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