Forum Discussion
Solved
Two different values for a filter in a chart
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) a...
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
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!
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