Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Jebilaya
Helper III
Helper III

No row total in matrix for measure

I have a measure in a matrix that is giving a column total but not a row total.  Any ideas?

 

Dax for the measure:

Count DR Slicer =
Var SV = SELECTEDVALUE('Driver Rating Slicer'[Rating])
Return Switch(True(), SELECTEDVALUE('Driver Rating Slicer'[Driver Category]) = "Warmth & Friendliness",calculate(countrows('Crew League Table'), filter('Crew League Table','Crew League Table'[Warmth & friendliness] = SV)),

SELECTEDVALUE('Driver Rating Slicer'[Driver Category]) = "Social Distancing",calculate(countrows('Crew League Table'), filter('Crew League Table','Crew League Table'[How well social distancing was maintained] = SV)),

SELECTEDVALUE('Driver Rating Slicer'[Driver Category]) = "Willingness to Help",calculate(countrows('Crew League Table'), filter('Crew League Table','Crew League Table'[Willingness to help] = SV)),

SELECTEDVALUE('Driver Rating Slicer'[Driver Category]) = "Care & Attention with handling delivery",calculate(countrows('Crew League Table'), filter('Crew League Table','Crew League Table'[Care & attention with handling delivery] = SV)))

 

Jebilaya_0-1651746588609.png

 

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

Try:

row totals = SUMX(VALUES(Table[Category]), [Count DR slicer])





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

1 REPLY 1
PaulDBrown
Community Champion
Community Champion

Try:

row totals = SUMX(VALUES(Table[Category]), [Count DR slicer])





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.