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 ,

 

Your table name means actual table name in your data model.

Measure = CALCULATE('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

    Hello.  I have revised the equation as advised, but is now giving me a different error:

     

    I am going to include this for references perhaps I am missing something too. 

    This is the Excel file that I am working on.  Its one of many tabs labaled, "Chargeability Details by OU"

     

    And this is my file in Power Bi

     

    Again, I am so sorry that this is taking a long time.  I am still new at this and really enjoy learning from all of you.  Thank you for all of your help.  I am sorry if this request is bothering some of you.  I deeply apologize.


    Thank you again for helping.  You are going above and beyond to help me learn.  I deeply appreciate it.