Forum Discussion
Selectedvalue
Show me in a table(Excel) what you are trying to achieve
I created a measure for A,B and C, and I got the following table
If you need to see the empty lines, you have to tick: Show item with no data
In fact, you do not need dax to achive that
I just set up the following relationship
Then I added a matrix with the following parameters:Rows: Group (if you need from filter)
Columns: group_last_year
Values: Count of CUSTOMER_NUMBER
The blank line is for D et E value
If you use everything for the excel file you shared
Hi, yes true. This measure is only for A. I have another measure only for B and C.
But your measure for A is wrong, only the first case will be evaluated as you do not have other condition than Table1[Group] = "A"
What you should do is something like:
Mymeasure =
Switch(TRUE(),
Table1[Group] = "A",MeasureForA,
Table1[Group] = "B",MeasureForB,
Table1[Group] = "C",MeasureForC
)
so my measure is totally wrong for what I need 😣
Show me in a table(Excel) what you are trying to achieve
I created a measure for A,B and C, and I got the following table
If you need to see the empty lines, you have to tick: Show item with no data
Seems like I can't upload an excel file here "The file type (.xlsx) is not supported". So I have uploaded it online: https://uploadnow.io/f/YYfFPKk
Thank you so much for your help 🙏 Hope the excel makes it clear what I need