Forum Discussion

Adavin's avatar
Adavin
Frequent Visitor
3 months ago
Solved

Subtraction calulation

Hello,   I have an issue when trying to subtract from a group code data item  any help greatly appreciated ADavin
Need Help
  • v-anbandari's avatar
    v-anbandari
    2 months ago

    Hi Adavin,
    Thank you for posting your query in the Microsoft Fabric Community Forum.

    I was able to reproduce your scenario in Power BI Desktop using my sample data.

    Using sample grouped data for Income, Pay, Non Pay, and Subs, I created DAX measures to calculate:

    • Individual grouped totals
    • Overall Operation Total
    • Income % against the Operation Total

    The calculation returned the expected result successfully.

    The percentage calculation was achieved using a DAX measure similar to:

    Income % =
DIVIDE(
   [Income Total],
   [Operation Total],
   0
)

    This approach works because the grouped labels (Income, Pay, Non Pay, etc.) are aggregated categories, so the calculation should be handled through measures rather than direct subtraction/division on grouped rows.

    For your reference, I am also attaching the sample .pbix file used to reproduce the scenario.

    Hope this helps.

Adavin's avatar
Adavin
Frequent Visitor
3 months ago

Hi,

Hopefully this expalins a little better.

 

Task to find out what the actual is for Income, Pay, Non Pay and so on

Using the data item [Codes] that contain individual codes .i.e 1001, 1002

To find out what codes relate Income I have grouped them and called the grouping 'INCOME'

I have them created groups for Pay, Non Pay etc with the related codes for each. Then added [Actual] to get a total for each.

 

You can see that the operation is a total of all Income, Pay, NON Pay and subs. I now need to take the Income/Operation and show as a %

ralf_anton's avatar
ralf_anton
Resolver I
3 months ago

...leider wird die Sache nicht klarer.

Willst Du die Ergebnisse nach den Codes aufsplitten? Wo kommen denn die Codes her? Aus einer anderen Tabelle? Dann musst Du eine Beziehung herstellen, einen Join bilden und kannst dann nach den Codes Gruppieren lassen.