Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
If I slice by Month Year instead of Quarter Year this Calculated column should be 2 not 4
I´ve tried to use AllExcept to keep filters from dim date but the result is 1:
Could you help me to find the right calculation ?
Thanks
Solved! Go to Solution.
Calculated columns are only calculated during data refresh, so they do not pay any attention to filters or slicers which may be set in a report. If you want something to dynamically respond to slicers you need to define it as a measure.
Calculated columns are only calculated during data refresh, so they do not pay any attention to filters or slicers which may be set in a report. If you want something to dynamically respond to slicers you need to define it as a measure.
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |