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

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ,

 

Create the following  measure and put it in the card visual:

 

 

Measure = CALCULATE(Your table name[
Utilisation for Chargeability Detail(Include Partners)],Your table name[
Operating Unit] = "Grand Total")

 

 

Best Regards,

Dedmon Dai

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Giving me errors