Need Help in Power BI visualisation

[Unknown_1]

Hi Team,

I have created this visual in power bi. I want to add the actuals which is a calculated measure against each of the business unit($m @ FY25 plan rate)

For eg against Lending what is the actual value of it and for Payments and so on.

How can that be achieved, appreciate your help.

 

[Anonymous · Accepted solution]

Hi  @Unknown_1 ,

I created some data:

If you want to calculate for each [business unit], you can consider placing the [business unit] in Column in the matrix visual and it will be calculated based on the grouping of fields placed in Row and Column.

Here are the steps you can follow：

1. Create measure.

I don't know your calculation logic, I created my own custom logic, [Plan%] to find the business unit grouping percentage of each Group, you can use filter() function in the measure to define the grouping logic calculation in it

Plan% =
DIVIDE(
    [Plan],
SUMX(FILTER(ALL('Table'),'Table'[Group]=MAX('Table'[Group])),[Value]))

2. Result:

If the above results do not meet your expectations, you can express the expected results in the form of a picture, we can better help you!

Best Regards,

Liu Yang

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