Forum Discussion
Two different values for a filter in a chart
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
nveliss , not very clear.
You can removefilter or all on Flag
calculate([measure],removefilters(Table[flag])
calculate([measure],filter(all(Table),Table[flag]="Y")
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
nveliss , I think I am still not on the same page. But have tried dragging the column having yes, no value to the legend ?