Forum Discussion
Solved
Dax filtered value issue
I have a column that consists of simple Yes/No values. I have the below DAX that works perfectly fine for finding the count of Yes values. However, I also need to return a value of zero for all value...
You can create a column like this and then have sum
new Column = if([Column] IN { "Yes" },1,0)
measure =sumx(Table, if([Column] IN { "Yes" },1,0))
Or , use this option with your formula - Show item with no value
You can create a column like this and then have sum
new Column = if([Column] IN { "Yes" },1,0)
measure =sumx(Table, if([Column] IN { "Yes" },1,0))
Or , use this option with your formula - Show item with no value