Forum Discussion

e0318476's avatar
e0318476
Helper I
4 years ago
Solved

Returning a result with 1 DAX function and 1 Column

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!

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    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's avatar
    AlexisOlson
    4 years ago

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

4 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    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
    )
)
  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

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