Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
100 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |