CODEWITHSUNDEEP
powerbipercentage
Amar Das
Amar Das

Reputation: 13

Calculate Percentage of RowTotal instead of GrandTotal in Power BI

I am new in Power BI, I am trying to calculate the percentage based on the rowTotal instead of GrandTotal. for example - with my dataset in excel -

RAW Data is like -enter image description here

from these raw data I want the calculation like - enter image description here

Upvotes: 0

Views: 2394

Answers (1)

Kin Siang
Kin Siang

Reputation: 2699

Very simple problem to be solved and accept the solution if helping:

  1. From the original table, create the Total measure:

    Total = SUM(Sheet2[Compliant]) + SUM(Sheet2[Non-Compliant])

  2. Create the Percentage measure

    Percentage = SUM(Sheet2[Compliant]) / (SUM(Sheet2[Compliant]) + SUM(Sheet2[Non-Compliant]))

The outcome using table report

enter image description here

Upvotes: 2

Related Questions