Forum Discussion

Nitraz's avatar
Nitraz
Frequent Visitor
3 years ago
Solved

DAX Measure - Count If

I have the below data loaded in PBI. Station Full name Employee ID Average score Assessment result Overall Assessment Summary Station 1 Jayesh Thundathil 11864 64% Competent   Sta...
Need Help
barritown's avatar
barritown
Solution Sage
3 years ago

Hello Nitraz,

You can try something like this:

In plain text for convenience:

Measure = 
COUNTX ( 
    FILTER (
        ADDCOLUMNS ( VALUES ( data[Full name] ), 
                    "Counter", 
                    VAR _CurrentName = [Full name]
                    RETURN COUNTX ( FILTER ( data, [Full name] = _CurrentName && [Assessment result] = "Competent" ), [Full name] ) ), 
    [Counter] = 2 ), 
[Full name] )

 Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

  • Nitraz's avatar
    Nitraz
    Frequent Visitor
    3 years ago

    Hi barritown 

    Thanks for creating the measure to show who are 'competent' but I need to show who are 'not competent' as well in the same chart as shown below. How to proceed?