Forum Discussion
Report edit with 'If' Statements
Since both columns are in the same table I'd suggest PQ over a measure. Just add a logical column to determine an overall satus based on the possible combinations of the two other statuses. Then filter on that.
A measure would be more like if you have the info in two different places and need a view that dynamically determines it live based on the other filters currently applied. It also can be a pain to filter by because it needs a visual context to evaluate, so can't be in a report slicer or page level filter.
Since both columns are in the same table I'd suggest PQ over a measure. Just add a logical column to determine an overall satus based on the possible combinations of the two other statuses. Then filter on that.
A measure would be more like if you have the info in two different places and need a view that dynamically determines it live based on the other filters currently applied. It also can be a pain to filter by because it needs a visual context to evaluate, so can't be in a report slicer or page level filter.
thank you, i used power query and then the if statement, so far so good..
also reviewed this youtube link
https://www.youtube.com/watch?v=HQ4RNJiVurI
