Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a table like this :
ID | Color | Texture | Taste |
S01 | Yes | Yes | Yes |
S02 | No | No | No |
S03 | Yes | Yes | Yes |
S04 | Yes | No | Neutral |
S05 | No | No | Neutral |
S06 | No | No | Yes |
And I would like a table like this :
Yes | Neutral | No | |
Color | 3 | 0 | 3 |
Texture | 2 | 0 | 4 |
Taste | 3 | 1 | 2 |
I can't find how to do that on the report neither on the data section.
Any ideas?
Thanks in advance!
Solved! Go to Solution.
The reason you're getting blank is because of the formula you've used for Return.
You've used a fullstop instead of a comma in the formula.
I've updated the formula to make it easier.
Also another issue you have is that your data has results that are based on Scales table Echelle 2 column
But you've used Echelle 1 column to try to get your results through DAX
So results won't match because the value doesn't match your data table.
As such I've shown this in the Scales table by doing 2 formulas. 1 based on Echelle1 and one based on Echelle2 to demonstrate
Select your ID column in Power Query and unpivot the other columns. Trivial from there to stick the relevant columns into a matrix
@Anonymous Hi, I'm sorry but I'm missing something. When I adapt your formula to calculate each row, I get blanck cells only.
Would you be kind enough to check my file and let me know what I did wrong? It would help me a lot!
The reason you're getting blank is because of the formula you've used for Return.
You've used a fullstop instead of a comma in the formula.
I've updated the formula to make it easier.
Also another issue you have is that your data has results that are based on Scales table Echelle 2 column
But you've used Echelle 1 column to try to get your results through DAX
So results won't match because the value doesn't match your data table.
As such I've shown this in the Scales table by doing 2 formulas. 1 based on Echelle1 and one based on Echelle2 to demonstrate
ok I see now! thank you so much for quick help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |