Powerbi DAX measure showing different result for Card and Tabular visual

[joepath]

Attached the powerbi report in the below link.

https://www.dropbox.com/s/vymoe7ylny79ls8/ModelTest.pbix?dl=0

In the report MutiIfCrossEncCount2 measure showing different result when using in Card and tabular visual with 

Activity type slicer.

but when removed the Relationship between the cds and review matrics table then both card and tabular visual show the matching value. 

What should i change in MutiIfCrossEncCount2  so it will work correctly? 

Let me know if more information is needed.

[v-danhe-msft]

Hi @joepath ,

This problem could due to items in different tables could not be One-to-one correspondence with your relationship, it will cause some item will correspondence blank, you could change the relationship to both and it will filter for each tables:

Result:

Regards,

Daniel He

[joepath]

@v-danhe-msft  Thanks for the reply.

Actually, result 7 is correct, in the cds tabular report one cds is missing because it not present in Review Matrix table. can't we change in the dax at the time of MutiIfCrossEncCount2 calculation, ignore the cds filter and do the calculation, and reactivate the filter when cds use as a filter? 

if we use the CDS column from 'Encounter Detail' table then results come correct. the same result I want when I use CDS column from CDS table.

And the approach I am using in MutiIfCrossEncCount2  measure for disconnected fact table is the right way to go, or is there any other better approach?

Basically, I want to pass Org_encounter_key value in encounter table based on the filter selection in 'clarification detail new' or 'Review matrix' fact table.