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

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

If the totals in your table are correct, you can just put those same measures (or columns with same aggregation selections) into a card visual (either separate single cards or all into the same multi-card visual.

Pat

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello,

    Sorry I am not really sure how to go about aggregation using calculations.  My intentions of using the card is to place it next to a graph I have already calculated and list it as such: