Forum Discussion
Solved
Multiple row and Column Add up (Remove Duplicates)
I am currently working on a project using a grading system and want to display total% of an individuals skillset. The grading system works using the below image (I've only used my own test ID but in ...
Hi Altonga
You can try the following
%Trained =
MAX ( 'Table'[Scenario1%] ) + MAX ( 'Table'[Scenario2%] )
+ MAX ( 'Table'[Scenario3%] )
+ MAX ( 'Table'[Task1%] )
+ MAX ( 'Table'[Task1%] )Hi tamerj1,
Thank you so much for your reply, this worked perfectly! I have noticed that it has affected one of my other visuals which I was showing a top level view for the training records. Please see below. (The top visual.)
Is there a way to make the data from the previous solution work in such a view?
Hi tamerj1 , So If there was some way to use the data created from the measure you helped me with before to display on a visual somewhat to the above image? Showing the number of indiviuals who have acheived either 10%, 20% and so on. Apologise if not clear I'm having a hard time explaining it myself haha.
