Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to create MATRIX table with hierarcy on (Region, Office, Manager) and all other columns will have aggregate (Measure/Calculated Field) value.
However, I would like to show all values whether they have aggregate value or not.
Source Table:
I am getting this result:
This is the formula i have applied to get correct count:
Expected Result:
I would like to see all Region, Office and Manager whether they have value or not. With the formula i am using i can only see who has value.
It does look like i am making some mistake in formula but not sure. I tried by GROUPBY and ALLEXCEPT also but didn't work.
Thanks
Solved! Go to Solution.
Hi,
Quick question though,
Is there a way I can put blank instead of 0.
I did try with BLANK() instead of 0 but result was filtered out. I am getting expected result with 0 only, however i would like to put blank or empty cell instead of 0.
Thanks
Hi Greg,
Thank you so much it worked perfectly.
Thanks
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
56 |
User | Count |
---|---|
99 | |
92 | |
84 | |
74 | |
66 |