Forum Discussion

DoesNotCompute's avatar
DoesNotCompute
Regular Visitor
2 years ago
Solved

Filter by Multiple Column Value Conditions

Hi There,   I've been struggling with this for hours and can not figure a solution. Any help greatly appreciated.   I have a data set like the below. What I need to do via DAX (I'm trying to work...
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    Hi DoesNotCompute 

     

    I produced your required output as follows:

    An example of the dax formulae to achive this output is as follows:  

     

     

     

     

    Where the data model looks like below:

    Best regards,

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You can consider using PRODUCTX and throwing away the BLANK()  results.

  • DoesNotCompute's avatar
    DoesNotCompute
    Regular Visitor
    2 years ago

    I'm not familiar with PRODUCTX and the below solution from DataNinja777 worked great. However, I will spend some time exploring this avenue as well to improve my skills. Thank you for the suggestion.