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
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..

danextian's avatar
danextian
Super User
1 year ago

Hi JawaharPrem6 

 

here's a sample measure based on the data provided.

DIVIDE (
    [count measure],
    CALCULATE ( [count measure], ALL ( 'table'[tat column] ) )
)

 

If this doesn't resolve your issue, please provide more context,  and a workable sample data (not an image). Please refer to this post - https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • JawaharPrem6's avatar
    JawaharPrem6
    Helper I
    1 year ago

    Hi,

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

     

     

    • danextian's avatar
      danextian
      Super User
      1 year ago

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