Filter Measure by another Measure (again!)

[okusai3000]

Hello everyone,

Sorry to repeat this kind of topic, but after searching, I still don't find a proper answer.

I have a FACT table of alarms for every patient. Each of them can have 1 to 3 alarms. I need to make a DISTINCT count of ONLY the patients with 2 or more Alarms.

I've been trying formulas like the following but I only obtain BLANK.

Calculate(distinctcount('fact RatiosTLM'[Id Paciente]), filter('RatiosTLM', count('fact RatiosTLM'[Id Paciente])>1)

Any idea?

Thanks a lot!

[Anonymous]

Hi @okusai3000 

If I understand correctly

VAR T1=  GROUPBY('fact RatiosTLM','fact RatiosTLM'[Id Paciente],"@COUNT",COUNTX(CURRENTGROUP,'fact RatiosTLM'[Id Paciente]))
RETURN
COUNTROWS(FILTER(T1,[@COUNT]>1))

[okusai3000]

That was unbelievable FAST! Thank you so much!

[amitchandak · Accepted solution]

@okusai3000, Try a measure like

countx(filter(Summarize('fact RatiosTLM','fact RatiosTLM'[Id Paciente], "_1", count('fact RatiosTLM'[Id Paciente])),[_1]>1),[Id Paciente])