Forum Discussion
Solved
%age is wrong
Dear All, I require this result in power BI. I tried to work in PBI but the result is going wrong. Excel calculation Check both tables of PBI . Table name data dump, specialty, and n...
pls provide the sample data and the expected output based on the sample data. In this problem, I can't use DAX to get 134.
maybe try
COUNT(Datadump[Speciality])/CALCULATE(countrows(Datadump),ALL(Datadump))
Sorry Sir,
Excel result is
Total 134 , transfer 13
how you get total 134?
It is my total entries manage internaly and other than 13 refer.
Total entries in this table 134.
pls provide the sample data and the expected output based on the sample data. In this problem, I can't use DAX to get 134.
maybe try
COUNT(Datadump[Speciality])/CALCULATE(countrows(Datadump),ALL(Datadump))
Thank you brother it is working.