Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello
Is there any way to make "_dimension" assigned in this case to "values" can be variable, that is, that as I have selected in a swich / if I take one column or another?
IF r=1 _dimension = "DIM TABLE 1"
IF r=2 _dimension = "DIM TABLE 2"
IF ( r = 1, RELATED('dim1[fieldx]),
If (r = 2, RELATED('dim2[fieldy]),
"unknown value of r"
)
)
Proud to be a Super User! | |
| User | Count |
|---|---|
| 58 | |
| 44 | |
| 31 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 77 | |
| 66 | |
| 44 | |
| 24 | |
| 22 |