Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello
I'm trying to create a measure for each of the different dimensions codes as shown in Table 1. CUSTOMER, DEPARTMENT, etc
Table 1:
A relationship will be created (many to one) between the 'entry number' in table 1 and 'number' in table 2.
Table 2:
What DAX formula will I need to add measures and show them against the row in Table 2?
Thanks in advance,
Ross
Solved! Go to Solution.
Hi @RossBateman96,
I'm attaching a pbix file with my solution.
Proud to be a Super User!
Hi @RossBateman96,
Could you please share what the output that you're looking for?
Proud to be a Super User!
Hi @RossBateman96,
I'm attaching a pbix file with my solution.
Proud to be a Super User!
Thanks, I had to pivot by dimensionCode rather than DimensionName but got the required outcome
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
96 | |
90 | |
81 | |
69 |
User | Count |
---|---|
157 | |
125 | |
116 | |
111 | |
95 |