Forum Discussion

JawaharPrem6's avatar
JawaharPrem6
Helper I
1 year ago
Solved

% Calculation

Hi All, Need to calculate % like method as mentioned below,  in measure     Thanks Jawahar
  • 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..