Forum Discussion
Modelling and querying multiple related fact tables
Good day! Apologies if this is the wrong place to ask this sort of question. I have a relational data source with 3 fact tables which are related to each other and model patient doctor visit...
yvtoropov,
What is the DAX formula do you use to create the measure? What do you mean that "select ALL diagnoses in the report"? Do you use filters or directly select rows in the visual?
Regards,
Lydia
Hi Lydia,
I am using =DISTINCTCOUNT(LabComponentResultFact[EncounterKey]) and =DISTINCTCOUNT(DiagnosisEventFact[EncounterKey]) for measures.
By 'selecting all diagnoses' I mean when creating a pivot table report I put both measures on columns and all values in diagnosis dimension on rows.
Regards,
Yuriy
I am using =DISTINCTCOUNT(LabComponentResultFact[EncounterKey]) and =DISTINCTCOUNT(DiagnosisEventFact[EncounterKey]) for measures.
By 'selecting all diagnoses' I mean when creating a pivot table report I put both measures on columns and all values in diagnosis dimension on rows.
Regards,
Yuriy