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 ,

 

It's better that you can show us sample pbix file by onedrive for business , so we can help you more correctly.

 

Best Regards,

Dedmon Dai

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This is the Excel document that I am using to build my dashboard

     

    Also here is a screenshot of the pbix while I try to input the column for utlization within the card.

     

     

     

    Please let me know what exactly what else you need from the pbix file (I am sorry I am a bit new to the whole Power Bi experience and I was just taught the basics.  The rest I am learning from other materials, this wonderful community and YouTube).

     

    Thanks again