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

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

Accepted Solutions
ysapiyev Member
Member

Re: Data selection in heirarchy

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
Community Support Team
Community Support Team

Re: Data selection in heirarchy

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 Member
Member

Re: Data selection in heirarchy

@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

Community Support Team
Community Support Team

Re: Data selection in heirarchy

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 Member
Member

Re: Data selection in heirarchy

@v-piga-msft,

 

Attached file to onedrive. 

 

Regards,

Yerkhan

Community Support Team
Community Support Team

Re: Data selection in heirarchy

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 Member
Member

Re: Data selection in heirarchy

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors