Forum Discussion

thiamhuat2026's avatar
thiamhuat2026
Icon for Helper III rankHelper III
4 months ago
Solved

Display Chart with Normalized Values

I have this Count of Case ID by Category.  But I want to display its normalized values which is equal to the (Sum of CaseID)/`EDU_with_Carpark'*100. How can I get the normalized values?  
Need Help
  • krishnakanth240's avatar
    krishnakanth240
    4 months ago

    Can you try this

    Normalized Value (%) =

    DIVIDE(COUNT('Table'[Case ID]),    SELECTEDVALUE('Table'[EDU_with_Carpark])) * 100

krishnakanth240's avatar
krishnakanth240
Icon for Super User rankSuper User
4 months ago

Hi thiamhuat2026 

 

Can you try these measures

Total Cases =COUNT('Table'[Case ID])

Total EDU =SUM('Table'[EDU_with_Carpark])

 

Normalized Value (%) =

DIVIDE([Total Cases],[Total EDU])

* 100

  • thiamhuat2026's avatar
    thiamhuat2026
    Icon for Helper III rankHelper III
    4 months ago

    thanks for the prompt reply. I actually do not need to sum the Total EDU, but just the Total Cases divide by the [EDU_with_Carpark]. How should the Normalized Value (%) be modified?

    • krishnakanth240's avatar
      krishnakanth240
      Icon for Super User rankSuper User
      4 months ago

      Can you try this

      Normalized Value (%) =

      DIVIDE(COUNT('Table'[Case ID]),    SELECTEDVALUE('Table'[EDU_with_Carpark])) * 100

      • Vinodh247's avatar
        Vinodh247
        Icon for Super User rankSuper User
        4 months ago

        Try this, made minor changes to suit:

        Normalized Value (%) =
        DIVIDE(COUNT('Table'[Case ID]), MAX('Table'[EDU_with_Carpark]), 0) * 100