Forum Discussion

JawaharPrem6's avatar
JawaharPrem6
Icon for Helper I rankHelper I
1 year ago
Solved

% Calculation

Hi All, Need to calculate % like method as mentioned below,  in measure     Thanks Jawahar
Need Help
Tips and Tricks
  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    1 year ago

    JawaharPrem6 , Use the below DAX and format it as percentage

    Percentage = 
var num = COUNT(EU_Data[TAT])
var den = CALCULATE(COUNT(EU_Data[TAT]),ALL(EU_Data))
RETURN
DIVIDE(num,den,0)

     

    Did I answer your question ? Please mark my post as a solution.

     

    Thanks,

    Jai

  • JawaharPrem6's avatar
    JawaharPrem6
    1 year ago

    Hi Jai,

    thank you its works..

JawaharPrem6's avatar
JawaharPrem6
Icon for Helper I rankHelper I
1 year ago

Hi,

thanks for your time, i used the mentioned dax but iam getting this error.

 

 

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

It's my first time seeing not being able to use % in a measure name. Have you tried renaming it?