%age is wrong

[naseem_1973]

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 new encounter column names.

When I divide  "specialty" column count with  "new encounter" count then %age is wrong. 

Specialty %age = DIVIDE([Transfer],[New Encounter Count],0)

Specialty = COUNT(Datadump[Speciality])/CALCULATE(COUNT(Datadump[Speciality]),ALL(Datadump[Speciality]))

[ryan_mayu]

@naseem_1973 

confused about this. Is the last screenshot the same as the Excel calculation? 

Then what's the expected output?

[naseem_1973]

Sorry Sir,

Excel result is 

Total 134 , transfer 13

[ryan_mayu]

@naseem_1973 

how you get total 134? 

[naseem_1973]

It is my total entries manage internaly and other than 13 refer. 

Total entries in this table 134.

[ryan_mayu · Accepted solution]

@naseem_1973 

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_1973]

Thank you brother it is working.

[ryan_mayu]

you are welcome