Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Row % DAX

  Hello DAX Experts,   I am having a little trouble making DAX work as I envision it.   My expected result is the top table - Built-In Function.   For my bottom table, I am using DAX to have m...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi tamerj1 ,

     

    That is exactly what I am trying to do.

     

    Thank you for adding the PBIX file. 

     

    I think my Power BI might be buggy. I am puzzled as to why I get 100% in all the rows. Your PBIX file works exactly as I envision. My IT is not well versed in Power BI debugging. Maybe I should notify MS.

     

    At any rate, thank you very much!

     

     

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 
I hope this is what you're looking for

Able % of Row Total = 
DIVIDE (
    COUNT ( Able[Ability] ),
    CALCULATE (  
        COUNT ( Able[Ability] ),
        ALL ( Able[Rating] ) 
    )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi tamerj1 ,

     

    That is exactly what I am trying to do.

     

    Thank you for adding the PBIX file. 

     

    I think my Power BI might be buggy. I am puzzled as to why I get 100% in all the rows. Your PBIX file works exactly as I envision. My IT is not well versed in Power BI debugging. Maybe I should notify MS.

     

    At any rate, thank you very much!