Forum Discussion
JawaharPrem6
1 year agoHelper I
% Calculation
Hi All, Need to calculate % like method as mentioned below, in measure Thanks Jawahar
- 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
- 1 year ago
Hi Jai,
thank you its works..
JawaharPrem6
1 year agoHelper I
Hi Jai,
Thanks for yout time, i worked on your provided dax but iam getting error..
Thanks Jawahar
Jai-Rathinavel
1 year agoSuper User
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
- JawaharPrem61 year agoHelper I
Hi Jai,
thank you its works..