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
I been trying to search information on how to solve my issue but no luck so far.
My model looks schematically like this:
The measure is Duration = Calculate (Sum Inc. [Duration], Inc. [Major Inc] = "Accepted")
My desired outcome is a Matrix like this:
Meaning even though Some services did not logged any duration are still visible in the Matrix. But what I actually get is this:
If under Customer at least one service logged duration time, the matrix shows only that service, otherwise it shows them all.
The "Show items with no data" option is clicked on the Business Services attribute on the rows.
Is there a way to accomplish that?
Thanks!
Solved! Go to Solution.
Hi, @Devesa_
Can you show what's put in the rows and columns of the matrix?
If this option doesn't work, it's still a problem about measure and relationships.
The sample you provided are not enough to analyze, and the relationship is messy, so it is difficult for me to give advice. Can you provide a more complete sample?
Best Regards,
Community Support Team _ Janey
Hi, @Devesa_
Can you show what's put in the rows and columns of the matrix?
If this option doesn't work, it's still a problem about measure and relationships.
The sample you provided are not enough to analyze, and the relationship is messy, so it is difficult for me to give advice. Can you provide a more complete sample?
Best Regards,
Community Support Team _ Janey
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 |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |