Forum Discussion

naseem_1973's avatar
naseem_1973
Icon for Helper I rankHelper 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...
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))

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

naseem_1973 

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

Then what's the expected output?

  • naseem_1973's avatar
    naseem_1973
    Icon for Helper I rankHelper I
    2 years ago

    Sorry Sir,

    Excel result is 

    Total 134 , transfer 13

      • naseem_1973's avatar
        naseem_1973
        Icon for Helper I rankHelper I
        2 years ago

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

        Total entries in this table 134.