Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need Help With Calculations - DAX Maybe?

Hello all.  Hope you're doing well and staying safe.  I am finally at the last stretch of finishing my dashboard.  However, I need help with creating a card that displays a total percentage.  I know ...
Need Help
Tips and Tricks
Tutorial Requests
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    Use the following measure:

     

    Measure = CALCULATE(MAX('Chargeability Detail by OU'[
Utilisation for Chargeability Detail(Include Partners)]),'Chargeability Detail by OU'[
Operating Unit] = "Grand Total")

     

    Best Regards,

    Dedmon Dai

Anonymous's avatar
Anonymous
Not applicable
5 years ago

First off, I want to thank you for taking this amount of time in helping me try to resolve this issue.  I really appreciate it.

 

I have tried your suggestion and it gave me this result.  What I would like it to be is a % total which would be 68% (utilization percentage exluding partners) and 66% (utilization percentage including partners).

 

With the measurement you provided, I recieved this:

Thanks again.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

The image did not show up for some reason.  Let me try it again: