Forum Discussion
Unable to display values in Level2 and Level3 Matrix visual in Power Bi
I am trying to create Level1, Level2 and Level3 matrix visual and unable to display custom calculations in Level2. below is the sample data to construct the visual.
Data:
| Level1 | Level2 | Level3 | Value |
| A | AA | AAA | 5 |
| A | AA | AAAA | 10 |
Matrix Visual: Trying to display as mentioned below in Matrix visual but i am not able to display values in Level2
| -A | |
| --AA | 50 |
---AAA | 5 |
---AAAA | 10 |
How can this be handled?
Thanks & Best Regards,
AJ
Thanks a lot. it resolves all my issues.
9 Replies
thanks for your reply.
I am calculating average (5/10)*100 from backend and the data will come from SQL database. And i just want display the values only on Level2 & Level3
- Ritaf1983
Super User
Hi DevMaster again 🙂
I'm still not sure I understand.
But if you just want to show levels 2 and 3 you can achieve it with DAX
According to the hierarchy level, it shows the calculation that you "tell" himSunValue = if (ISFILTERED('Table'[Level2]),sum('Table'[Value]),if(ISFILTERED('Table'[Level1]),BLANK()))If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly