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

8 Replies

  • 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?

         

         

  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    Super User
    1 year ago

    JawaharPrem6 Create a measure and format it as percentage like below

     

     

    Percentage = 
var num = SUM(YourTable[Count])
var den = CALCULATE(SUM(YourTable[Count]),ALL(YourTable))
RETURN
DIVIDE(num,den,0)

     

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

     

    Thanks,

    Jai

    • JawaharPrem6's avatar
      JawaharPrem6
      Helper I
      1 year ago

      Hi Jai,

      Thanks for yout time, i worked on your provided dax but iam getting error..

       

      Thanks Jawahar

      • Jai-Rathinavel's avatar
        Jai-Rathinavel
        Super User
        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