Forum Discussion

naseem_1973's avatar
naseem_1973
Helper I
2 years ago
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 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]))

 

 

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    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))