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

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