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

Click on an open area on your report page, then click on the Card visual in the visualizations panel.  If you have measures created, just drag it to the card.  If no, drag the column with those values to the card and choose the appropriate aggregation (probably sum) with the pull-down arrow on that column in the card field well.

Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello again.  I have done what you have advised, however, the card is not showing me a percentage much less the amount that I have caclulated within the Excel document.

    I did drag the "Utilization for Chargeability Details (Not Including Partners) into the card and it is showing me this number.  If I do change it to a percentage format, it would show me this:

     

     

    Please advise.  What am I doing that is wrong?  Thank you again for all of your help.  I am sorry that I keep bothering you.