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
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 needIn 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
Such a simple solution. It works. Thaaaaaaaaaaaanks so much 🌼