Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello everyone,
I am getting nuts trying to solve this problem. I cannot get to work the interaction with this graph and the matrix. If I click on the columns, doesn't filter anything.
**Adh SAHS >4hs MS:=
CALCULATE(
CALCULATE(
CALCULATE('fact prescripciones'[Pacientes Activos],
filter(all('fact Monitorizacion'[*Fecha Recogida]),LASTDATE('fact Monitorizacion'[*Fecha Recogida])<=max('dim Fecha'[Fecha])),
filter(all('fact Monitorizacion'[*Fecha Recogida]),LASTDATE('fact Monitorizacion'[*Fecha Recogida])>=min('dim Fecha'[Fecha])),
'fact Monitorizacion'[*Adh SAHS >4hs]="cumple"),
CROSSFILTER('fact Prescripciones'[Id Prescripcion],'fact Visitas'[Id Prescripcion],NONE)),
filter(ALLSELECTED('fact Prescripciones'),[**Dias_Trat]>180))
Pacientes Activos:= calculate(DISTINCTCOUNT('fact Prescripciones'[Id Paciente]),
all('dim Fecha'),
FILTER(ALL('fact Prescripciones' [Fecha Fin Tratamiento MOD]),'fact Prescripciones' [Fecha Fin Tratamiento MOD] >=min('dim Fecha'[Fecha])),
FILTER(all('fact Prescripciones'[Fecha Inicio Tratamiento]),'fact Prescripciones'[Fecha Inicio Tratamiento] <= max ('dim Fecha'[Fecha])) ,
FILTER(ALL('fact Prescripciones'[Fecha Inicio Tratamiento]),'fact Prescripciones'[Fecha Inicio Tratamiento] <> value("01/01/1900")))
And this are the relations:
I really appreciate any help,
thanks
Hi, @okusai3000
Is it convenient to provide sample file for testing?
Best Regards,
Community Support Team _ Eason
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.