Forum Discussion

bamcdonough's avatar
bamcdonough
New Member
3 years ago
Solved

Distinct Count IDs, COUNTROWS with Multiple Filters

Hi Everyone,   I'm trying to analyze training data and I want to create a calculation that shows how many incompete trainings each employee has this year (2022).     I "Grouped By" one report (Tr...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi bamcdonough ,

     

    Please check the formula.

    measure = CALCULATE(COUNT(yourtable[User - User ID]),FILTER(yourtable,yourtable[Transcript - Transcript Status] in {"In Progress / Past Due","Registered / Past Due"}&&yourtable[Training - Training Title] in {"Insider Trading 2022 (GCG_1H22)","Economic Sanctions, Antiboycott and Export Control Laws 2022 (GCG_1H22)","Global Information Handling 2022 (GCG_1H22)"}))

     

     

amitchandak's avatar
amitchandak
Super User
3 years ago

bamcdonough , Try like

 

2022 Incompletes =
CALCULATE (
COUNTROWS ( Training_All_In_Data ),
FILTER (
Training_All_In_Data,
Training_All_In_Data[Transcript - Transcript Status] in { "In Progress / Past Due", "Registered / Past Due"}
&& Training_All_In_Data[Training - Training Title] in { "Insider Trading 2022 (GCG_1H22)", "Economic Sanctions, Antiboycott and Export Control" , "Global Information Handling 2022 (GCG_1H22)" }
)
)

 

 

But the measure seems fine. hope you are creating measures