Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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])
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))
That was unbelievable FAST! Thank you so much!
@okusai3000, Try a measure like
countx(filter(Summarize('fact RatiosTLM','fact RatiosTLM'[Id Paciente], "_1", count('fact RatiosTLM'[Id Paciente])),[_1]>1),[Id Paciente])
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |