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!

     

     

amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , Why are taking the rating below?

Like ?

 

Able % of Row Total = DIVIDE(
COUNT(
Able[Ability]),
CALCULATE(
COUNT(Able[Ability] ) ,
removefilters(Able[Rating])))

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi amitchandak,

 

Thank you for your reply. Maybe these two tables will better explain my logic.

 

With the Total Abilities per Rating DAX, I want to figure out a way to divide Rating by Sum responses. For examples, Analyze data to measure success and extremely difficult has one response. 1 response divided by 161 responses equals 0.62% not .08%. 

 

 

 

I tried the DAX I think you recommended.  This is the output.

 

 

 

Please let me know If you have any questions.