Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Help with flatting parent, child values for hierarchy

The following table is a matrix table. The values are dax measure divided by dax measure and there is a hierarchy in the rows.

I am trying to get a value instead of "infinity". The infinity caused because there is a relevant value only to the last hierarchy field (I think), and I am trying to flat it for all the hierarchy. If I will remove the first two hierarchy field, I will get the values I need for the rest of the fields. Why do i need to remove it to get the result? Is there a way to keep it?

Thanks in advance.

 

Link to the pbix file: https://drive.google.com/open?id=1FvHaYckXQpmqgmJxJ3qrtdjsogjz6HYb

1 REPLY 1
Anonymous
Not applicable

Both of the dashboards are the same data. One is with a slider that changes the measures of the table and the second is just one measure that i have an issue with.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.