Forum Discussion
naseem_1973
Helper I
2 years ago%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...
- 2 years ago
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))
ryan_mayu
Super User
2 years agohow you get total 134?
naseem_1973
Helper I
2 years agoIt is my total entries manage internaly and other than 13 refer.
Total entries in this table 134.
- ryan_mayu2 years ago
Super User
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))
- naseem_19732 years ago
Helper I
Thank you brother it is working.
- ryan_mayu2 years ago
Super User
you are welcome