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 n...
  • 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))