Forum Discussion

okusai3000's avatar
okusai3000
Helper IV
5 years ago
Solved

Filter Measure by another Measure (again!)

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 alar...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    okusai3000, Try a measure like

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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))