March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
Hi everyone.
I have a report with live connection to SSAS cube. There are hierarchy of org units: org_unit1 => org_unit2 => org_unit3.
I have values in measures for org_unit2, so at org_unit1 they sum, which is correct, and at level of org_unit3 it shows value for org_unit2. Is it possible to get 0 at org_unit3 level?
Regards,
Yerkhan
Solved! Go to Solution.
Hi,
I solved it by using calculations in OLAP cube, by setting case for hierarchy level. Here is more information.
Regards,
Yerkhan
Hi @ysapiyev,
Sorry for the delay.
I have values in measures for org_unit2, so at org_unit1 they sum, which is correct, and at level of org_unit3 it shows value for org_unit2. Is it possible to get 0 at org_unit3 level?
Is the Value column a measure? If it is, please share the formula of the measure.
I'm confused about getting 0 at org_unit3 level. If it is convenient, could you share your desired output and explain your logic.
Best Regards,
Cherry
Hi,
I solved it by using calculations in OLAP cube, by setting case for hierarchy level. Here is more information.
Regards,
Yerkhan
Hi @ysapiyev,
I have a report with live connection to SSAS cube. There are hierarchy of org units: org_unit1 => org_unit2 => org_unit3.
I have values in measures for org_unit2, so at org_unit1 they sum, which is correct, and at level of org_unit3 it shows value for org_unit2. Is it possible to get 0 at org_unit3 level?
Based on your infromartion, I'm not very claer about "Is it possible to get 0 at org_unit3 level?".
More details will be more helpful.
If it is convenient, could you please share some data sample which could reproduce your scenario and your desired output so that I can have a test?
Best Regards,
Cherry
Attached report. You can see, that org_unit_2_2 has value 1400. How can I save this value and set value of org_unit_2_2_1 and org_unit_2_2_2 to 0?
Regards,
Yerkhan
Hi @ysapiyev,
I cannot have access to your report as I don't have permission.
You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
99 | |
88 | |
70 | |
61 |
User | Count |
---|---|
140 | |
121 | |
106 | |
98 | |
94 |