Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Switch True

DAX experts,  Here is how my data is set up: ID:       Reason 1       Reason 2      Reason 3       Reason 4 1                    Correct          Incorrect      Incorrect       Correct 2         ...
  • Rahal's avatar
    Rahal
    6 years ago

    So, with the structure of your data you can only get something like this :

    Otherwise you need to transform your data, for that u need to use SQL,

    here i'm ganna start by creating my table Check :

    Then i can tranform it also with Sql :

     

    So finaly i can get what i need on Power BI :

     

kentyler's avatar
kentyler
Solution Sage
6 years ago

try changing your data to this format:

ID:       Reason        Response     

1                   1         Incorrect     

1                 2       Correct         

1                  3         Incorrect      

1                    4          Incorrect      

2                    1       Correct         

2                  2         Incorrect      

2                  3          Incorrect    

2                4      Correct         

 

it will make your calculation much easier

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

That's a good idea. The only thing is I really have around 20 reasons and an ID can appear multiple times if it was incorrect for any reason the previous time it was submitted. 

 

So this table would then grow exponentially and be extremely large if I am understanding it correctly.