Returning a result with 1 DAX function and 1 Column

[e0318476]

Hi everyone, 

I need help in this

'Percentage of Completion' is in calculated from DAX (i.e. Divide 'Modules Completed' with 'Total Modules').

I want to count how many people have completed the 100% of the course. The returning value should be 3. 

I am not sure how to write a DAX between 'Full Name' and 'Percentage of Completion'. 

Please help, thank you!

[ryan_mayu · Accepted solution]

@e0318476 

maybe you can try this

Measure = 
VAR tbl=ADDCOLUMNS(SUMMARIZE('Table','Table'[Full Name],"module complete",sum('Table'[modules completed]),"module total",sum('Table'[Total Modules])),"percentage of completion",DIVIDE([module complete],[module total]))
return CALCULATE(DISTINCTCOUNT('Table'[Full Name]),FILTER(tbl,[percentage of completion]=1))

[AlexisOlson · Accepted solution]

Try one of these:

SUMX (
    VALUES ( Table1[Full Name] ),
    IF ( [Percentage of Completion] = 1, 1 )
)

COUNTROWS (
    FILTER (
        VALUES ( Table1[Full Name] ),
        [Percentage of Completion] = 1
    )
)

[e0318476]

Thank you very much @AlexisOlson ! The first solution is useful to resolve my question!

[ryan_mayu · Accepted solution]

@e0318476 

maybe you can try this

Measure = 
VAR tbl=ADDCOLUMNS(SUMMARIZE('Table','Table'[Full Name],"module complete",sum('Table'[modules completed]),"module total",sum('Table'[Total Modules])),"percentage of completion",DIVIDE([module complete],[module total]))
return CALCULATE(DISTINCTCOUNT('Table'[Full Name]),FILTER(tbl,[percentage of completion]=1))

[e0318476]

Thank you @ryan_mayu !