Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I need help with the below query:
MRN Diff EID:=
var __EID = CALCULATETABLE(SUMMARIZE(table1,table1[FACILITY_MRN], "Distinct EID",DISTINCTCOUNTNOBLANK(table1[EID])),
COVID[EID_Check]<>"EID Not Available")
return
SUMX(FILTER(__EID,[Distinct EID]>1),1)
The idea was to count how many people have multiple sub ids (EID) for their main ID (MRN).
The measure works great. But when added to a visual with the date as the axis, it becomes incredibly slow. any advice on how to tune the above query?
Solved! Go to Solution.
Hi @arzukari
Try
MRN Diff EID :=
VAR __EID =
FILTER (
DISTINCT ( table1[FACILITY_MRN] ),
CALCULATE (
DISTINCTCOUNTNOBLANK ( table1[EID] ),
COVID[EID_Check] <> "EID Not Available"
) > 1
)
RETURN
COUNTROWS ( __EID )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @arzukari
Try
MRN Diff EID :=
VAR __EID =
FILTER (
DISTINCT ( table1[FACILITY_MRN] ),
CALCULATE (
DISTINCTCOUNTNOBLANK ( table1[EID] ),
COVID[EID_Check] <> "EID Not Available"
) > 1
)
RETURN
COUNTROWS ( __EID )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
This is amazing. It is so much faster now, thank you.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!