Forum Discussion
How to Make Column = Unfiltered Data
So my issue is as follows: I have a set of data as follows: Department Name productivity % A 10% B 30% C 5% D 15% E 60% I wanted to construct a DAX fun...
the issue lays in this expression... I am trying to say IF(Department Name = {A and B and C and D and E} then 20%... but I don't know the syntax to do so .. I tried IF(Department Name IN {A,B,C,D,E} then 20% but it gives me wrong result. is there any way to make the column equal all the combined departments so when filter is removed it retains the 20% value?