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

View solution in original post

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors