Forum Discussion

Altonga's avatar
Altonga
Frequent Visitor
3 years ago
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 ...
DAX
rows
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Altonga 
    You can try the following

    %Trained =
MAX ( 'Table'[Scenario1%] ) + MAX ( 'Table'[Scenario2%] )
    + MAX ( 'Table'[Scenario3%] )
    + MAX ( 'Table'[Task1%] )
    + MAX ( 'Table'[Task1%] )
Altonga's avatar
Altonga
Frequent Visitor
3 years ago

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? 

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Altonga 

Can you please explain further?