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,
sorry for the strange title - but i dont know how to name my question better.
I have the two 2 Dimensions
[FREEZE]
[TIME]
and one Fact
[FACT]
used in a Matrix.
[TIME].[MONTH] as columns, [FREEZE].[NAME] as rows and [FACT].[MEASURE] as value.
As you can see in the followling screenshot a value only exists when [TIME].[MONTH] and [FREEZE].[NAME] are equal.
That will always be the case.
I now want to achive a display of the matrix like that:
So i think i have to remove [FREEZE].[NAME] from the rows and put it somehow in my calculated measure, right?
Kind regards
Jack
@lbendlin i get 1 row but with "wrong" data because i've lost the FREEZE[NAME] context in my measure now
yes. What happens if you do only the first part (remove FREEZE[NAME] from rows)?
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |