Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
93 | |
88 | |
35 | |
35 |
User | Count |
---|---|
154 | |
101 | |
80 | |
63 | |
54 |