A measure to exclude values from one column based on filtering from another column

[Anonymous]

I have the above data set and I am trying to get the sum of the question value except when the text in the Fail column is "yes". 

I've tried a few different measures, but when I select "yes" on the slicer, I'm having an issue getting it to ignore the question value data. I would value any assistance as I think I have been working on this too long and am overthinking the problem.

Thank you,

[Anonymous · Accepted solution]

Hi @Anonymous ,

Create a measure.

Sum Except Fail = CALCULATE(SUM(table[question value]),filter(all(table),table[Fail] <> "yes"&&table[date]=selectedvalue(table[date])))

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Create a measure.

Sum Except Fail = CALCULATE(SUM(table[question value]),filter(all(table),table[Fail] <> "yes"&&table[date]=selectedvalue(table[date])))

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Thank you for the prompt reply. I actually added an if statement and just zeroed out the score possible and took care of the Score Percentage that way. 

Thank you!