Dimention contains all three requirements

[tstackhouse]

I have the following senerio. I am looking for PATDOB's that have all three B, MR and O.  Is there any way the I could use a calculation or filter to only include PATDOB's that contain all three (B,MR,O). I am not sure if it is possible to use some type of subtotal in this situation and then filter on that. Any help would be great. Thanks!

rio

[v-yuezhe-msft · Accepted solution]

@tstackhouse，

Create the following columns in your table.

Column = IF(Table[Opiod/Benzo/MusicRe]="(Blank)" || Table[Opiod/Benzo/MusicRe]="",0,1)

Checkcolumn = CALCULATE(COUNT(Table[Column]),FILTER(ALLEXCEPT(Table,Table[PATDOB]),Table[Column]=1))

Then drag the Checkcolumn to Visual level filters of Matrix visual and set its value as follows.


Regards,
Lydia

[Ashish_Mathur]

Hi,

Share the link from where i can download your file.

[TomMartens]

Hey,

I would create this DAX statement to create a calculated column

Column = 
    IF(
        OR(OR('Table1'[B] = "", 'Table1'[MR] = ""),'Table1'[O] = "")
        ,"Some thing is missing"
        ,"Everything is there"
    )

This would create this result

Then it simple to use this column to filter the rows you want.

Hope this helps

Regards

Tom