help in matrix visualization

[Curious12964]

I want help in matrix visualization. I want to have a similar structure in PowerBI. Each team has a budget. I have to add values present under the "Value" column and substract the result from "Total Budget" to get "Budget to be used". Please help me to get this result. 

[Ritaf1983 · Accepted solution]

Hi @Curious12964 
Since Power BI visualizations are built in a way that aggregates values, similar logic applies to pivot tables. To achieve a similar result, each row should have a unique identifier at the category level, which will also dictate the display order. A row number or a date can be used to ensure the data is presented chronologically. This way, it is possible to achieve a result that is almost identical to the desired one.

Dax measures :
Total Budget = if(ISINSCOPE('Table'[Row id]),",MAX('Table'[Budget]))
Spent = SUM('Table'[Values])
Budget to be used = if(ISINSCOPE('Table'[Row id]),", [Total Budget]-[Spent])
Pbix is attached

If my answer was helpful please give me a Kudos and accept as a Solution.

[dharmendars007]

Hello @Curious12964 , 

I see the complexity in your visuals because if a row has blanks the corresponding numbers or values cannot be shown against that because there is no filter context present.

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN