cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ysapiyev
Responsive Resident
Responsive Resident

Data selection in heirarchy

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

1 ACCEPTED SOLUTION
ysapiyev
Responsive Resident
Responsive Resident

Hi,

 

I solved it by using calculations in OLAP cube, by setting case for hierarchy level. Here is more information.

 

Regards,

Yerkhan

View solution in original post

6 REPLIES 6
v-piga-msft
Resident Rockstar
Resident Rockstar

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ysapiyev
Responsive Resident
Responsive Resident

Hi,

 

I solved it by using calculations in OLAP cube, by setting case for hierarchy level. Here is more information.

 

Regards,

Yerkhan

v-piga-msft
Resident Rockstar
Resident Rockstar

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ysapiyev
Responsive Resident
Responsive Resident

@v-piga-msft

 

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ysapiyev
Responsive Resident
Responsive Resident

@v-piga-msft,

 

Attached file to onedrive. 

 

Regards,

Yerkhan

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors