Forum Discussion
Anonymous
7 years agoNot applicable
Apply total value not to every coloumn
Hey guys, do you know maybe if it is possible to decide on what coloumn to apply the total value? I have 3 measures (they have to stay measure, cannot change to coloumn because they are linked to...
- 7 years ago
Anonymous
Something like this ?
BU Status = IF ( ISFILTERED ( 'Incident Report'[Bus Unit] );
UNICHAR ( IF ( 'Incident Report'[Measure2 as Text] = "0"; 10003; IF ( 'Incident Report'[Measure2 as Text] = "2"; 10007; IF ( 'Incident Report'[Measure2 as Text] = "1"; 33 ) ) ) ) )where we're only adding the IF with the check (in red) to what you already had.
AlB
Community Champion
7 years agoHi Anonymous
Yes, within your measures, you can tell whether you are at the Grand total row by testing with something like:
ISFILTERED(Table1[Bus Unit])
and then returning blank in that case (or any other thing you want the mesure to return).