Visual-Level Filter Measure with Conditional Filter

[MStP]

Hello All,

Please see the link for the sample data file below.

I want to create a measure that acts as a visual level filter to include the following rows:

PO Cat = K or P

or

PO Cat = Blank, and PR Cat is K or P

In the sample data, the desired result is that the filter excludes PO1003.

https://drive.google.com/file/d/1XOp8YVIYCD71NXyVb3Oe_2lRT7FXUWgl/view?usp=sharing

It would also be useful to get the formula as if the PR Cat and PO Cat were in two different tables.

Please let me know if you need additional information.

Michael

[lbendlin]

Please explain why this would need to be a measure.  A calculated column seems sufficient.

[MStP · Accepted solution]

I don't know, I'm new at this. I guess the calculated column would deliver a combined value that I could filter in the visual? So the values would be whatever is in PO Cat + PR Cat and anything that's blank would be filtered out? This sounds reasonable to me. I used this expression and filtered out any blanks. I think this will work for me.

Acct Assignment Combine = COMBINEVALUES( ", ", ZQV_ME5A_ATC[AcctAssignmentCat], ZQV_ME5A_ATC[ZQV_ME2N_ATC.AcctAssignmentCat])

Michael