Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I need some help on using the SWITCH function for dynamis based on a measure.
I tried to add a calculated column which can diplay another column of the same table depending of a value: Value 1 will disply column A, Value 2 will display column B,....
The Value is determined by a measure based on a table not linked to the previous one.
Tables look like:
Column A | Column B | Column C | SWITCH |
a | b | c | |
aa | bb | cc | |
aaa | bbb | ccc |
Selection |
1 |
2 |
3 |
So if I select 1 from the Selection Table, then the SWITCH column from the other table will diplay column A.
Value is determined by the following measure:
- Measure = MIN('Selection'[Selection])
SWITCH column is as below:
- SWITCH = SWITCH([Measure];1;[Column A];B;;[Column B];C;;[Column C])
But when I tried to use in a visual I always get Column A in SWITCH whatever is selected in Measure.
See below an example: we see Measure = 2 & I should see the column B values. But instead I always got the column A
Do you know what is wrong with the Switch function ?
Thanks
Values in a calculated column are fixed. You'll need to create a measure.
Actually I already tried to built it as a measure. The problem is that the measures are added in visuals. As I want to keep the result as a distinct value (no aggregation) I was trying to built it as a custom column.
Is there any option "don't summarize" to apply on measures ? Or any way to change the formulas & make sure all resulta are distincts ?
Thanks
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |