Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Why is the variable 'calc' greyed out at the bottom?
Hi, @airwolf39
Try to put var calc = ..... just below measure name, and first SWITCH after return
Measure =
var X = [....]
var Y = [,,,,,]
RETURN
SWITCH....
Proud to be a Super User!
The total is now wrong because the variable is outside of the isinscope function
Text like VAR xyz = [...] cannot be inside, they should stay isolated and used the name xyz in expressions.
Proud to be a Super User!
| User | Count |
|---|---|
| 58 | |
| 45 | |
| 32 | |
| 16 | |
| 14 |
| User | Count |
|---|---|
| 82 | |
| 66 | |
| 42 | |
| 27 | |
| 25 |