Alternate of visual calculation EXPAND & COLLEASE

[samratpbi]

Hi,

I have a hierarchy where each level needs to be calculated differently. Basically instead of rolling up the previous level, it needs to be summed up and since the values are some ratios hence suming those will produce different result, which I want to achieve. I can see using EXPAND & COLLEASE visual functions, I am able to achieve the result which I need, however, I dont need those in a table and cant show the measure in the visual that I am using for visual calculation. Is there any alternate way to achieve similar functionalities in a DAX measure which EXPAND and COLLEASE does?

Thanks

[v-jiewu-msft]

Hi,

Based on the knowledge, do not found any function that has a similar effect to EXPAND and COLLEASE.

You can view the following document to learn more information.

Introducing EXPAND and COLLAPSE for visual calculations in Power BI - SQLBI

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...