Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.