Forum Discussion

Unknown_1's avatar
Unknown_1
Frequent Visitor
1 year ago
Solved

Need Help in Power BI visualisation

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's avatar
    Anonymous
    1 year ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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