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 ,

 

What's the last column(Utilisation % (Excluding Partners),Utilisation % (Including Partners) )in your table visual? Just put these two measure or column into card visual.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    It won't allow me to put the percentage.  I need 2 cards on the dashboard page.  One that represents the % of utlilization including partners and one card without partners.  However, when I do try to drag the column onto the card, it would give me this:

    Can you see the 4.58?

     

    And even if I convert it into a percentage format, it would give me this:

     

    Also, I used the formula (=E4/(C4+E4) as an example) to find the utlilization percentage.

    I would definately mark the issue as resolved once I recieve an answer.  Thank you again