Forum Discussion

sajarac's avatar
sajarac
Helper III
5 years ago
Solved

KPI Donut Chart

Hello Community. I had to stop doing some PowerBI reports for almost 2 years and it seems like I have to start from the beginning again.   Anyway.   I have a silly question and I would like to g...
Need Help
  • FrankAT's avatar
    FrankAT
    5 years ago

    Hi sajarac ,

    you can do it like this. Adapt the measure to your circumstances:

     

    Percentage Measure =
    DIVIDE(
        CALCULATE(SUM('Database'[GrossPounds]), Product = "B"),

        CALCULATE(SUM('Database'[GrossPounds]), ALL('Database'[Products])

    )

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

FrankAT's avatar
FrankAT
Community Champion
5 years ago

Hi sajarac ,

you can do it like this. Adapt the measure to your circumstances:

 

Percentage Measure =
DIVIDE(
    CALCULATE(SUM('Database'[GrossPounds]), Product = "B"),

    CALCULATE(SUM('Database'[GrossPounds]), ALL('Database'[Products])

)

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)