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%] )
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Altonga 

Can you please explain further?

Altonga's avatar
Altonga
Frequent Visitor
3 years ago

 

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.

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Hi Altonga 

    manually insert a single column table that contains the values you want to slice by, for example 0.1, 0.2, 0.3, etc.. let's call it Scores[Score]. This single column table shall remain disconnected from the main table or sny other table you have in your data model. 
    now you can use the following measure in a stacked column column chart were Scores[Score] is on the x-axis and the subject is on the legend

    SMX ( IF [%Trained] = SELECTEDVALUE ( Scores[Score] ), 1 )