FiIlter rows in Table visual based on value for a member - Power BI

[Aruljoy]

Hi All,

I need to filter all member records if a member has test results = 3 in any one of the rows. I need to filter this at Measure level. Cause the table visual need to perform based on filter visuals.

Thanks,

Arul Arockiam

[Ashish_Mathur]

Hi,

Is the Testresults column already available in your source dataset?

[Aruljoy]

yes, it is already there in source dataset

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[Aruljoy]

I have a date range filter. The measure is still calculating full rows from Dataset. Not from filtered records. Do you know how to fix it?

[Ashish_Mathur]

Not unless i see your file.

[Aruljoy]

If I filter by test date, The measure has to calculate accordingly. The screen shot is below

[parry2k · Accepted solution]

@Aruljoy sorry here is revised measure

Measure 7 = CALCULATE ( COUNTROWS ( Mem ), ALLEXCEPT ( Mem, Mem[MemId] ), Mem[TestResults] = 3)

[Aruljoy]

Thank you.. But I got a new issue. this measure breaking joins.. Can you help me how to fix it?

[parry2k]

@Aruljoy add a new measure and filter on this measure where measure value is not blank

Filter Visual = 
CALCULATE ( COUNTROWS ( Table ), ALLEXCEPT ( Table, Table[MemId] ) )

[Aruljoy]

Thanks for the response Parry2K. But I need to check if member has test results = 3 in anyone of the row