Forum Discussion
Post PartisanSuitable visual help required
Hey harshadrokade ,
you can do something like that with a matrix:
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHi harshadrokade,
Are your expected output as follows:
You can try measure as:
Measure = CALCULATE( CONCATENATEX('Table',MAX('Table'[Student]),","), FILTER( 'Table', 'Table'[Score A\ScoreB]=MAX('Table'[Score A\ScoreB]) && 'Table'[Score B]=MAX('Table'[Score B]) ) )The pbix is attached.
If I have not understood your needs correctly, please reply to me.
Best Regards,
LinkIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Post PartisanActually the matrix visual not showing Score B header. The same thing you can observe in the image you shared. Also unable to understand What should I add in 'Row' field, What in 'Column' field & what in 'Values' field. Values field is confustion as it has Student names & no any numeric values.
Most Valuable ProfessionalHey harshadrokade ,
yes, the header is confusing. Maybe name it differently.
The names I put because you asked for it. You can of course change it to numbers...
Check that:
And the settings for the Matrix:
Would that work?
Best regards
Denis