Two different values for a filter in a chart

[nveliss]

Hello,

I am trying to create a clustered column chart with two different values for the same filter.

I have two columns in my data. One is called Hours (where I have numerical values of hours) and the other column is called IsFlagged (where I have either Yes or No).

What I would like to do is to create two columns in my chart. One column with the sum of hours where Flag=YES and next to it a sum of total hours. If I add a slicer or a filter (on visual level) for the IsFlagged, it will filter everything.

Is the only way to do this by creating a new measure or column in my table? No link to any cube or live data.

Thanks!

[amitchandak]

@nveliss , not very clear.

You can removefilter or all on Flag

calculate([measure],removefilters(Table[flag])

calculate([measure],filter(all(Table),Table[flag]="Y")

[nveliss]

Thanks @amitchandak ,

this is what I eventually did. I created a Measure calculate(sum(Table[Hours],Table[flag]="Y") but was wondering whether there was a simpler way to do it through the visual/filter section by drag-dropping the field in the filter section. Hope it is more clear now...

Thanks again!

[v-lili6-msft · Accepted solution]

hi  @nveliss 

To my knowledge, create a new measure is the only way to do this, you could use ALL Function to get it.

https://radacad.com/now-you-see-me-use-cases-of-all-dax-function-in-power-bi

Regards,

Lin

[amitchandak]

@nveliss , I think I am still not on the same page. But have tried dragging the column having yes, no value to the legend ?