Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

PBI Distinct Count with multiple rows and column

Hi All, How to create measure to count DISTINCT IDs from multiple criteria from specific row and column? Below are sample dataset and the condition to create measures.   Criteria: How m...
Need Help
Ahmedx's avatar
Ahmedx
Super User
3 years ago

 pls try this

Measure = 
VAR _Filtertable = 
    DISTINCT( 
            ADDCOLUMNS( 
                SELECTCOLUMNS('Table'," ID",'Table'[Id]),
                       "CombinWords", CONCATENATEX(FILTER(ALL('Table'),'Table'[Id]=[ ID]),[prevstepid]&[stepid],"")))
VAR _Result = 
       FILTER(_Filtertable,
       CONTAINSSTRING([CombinWords],"Proc1") && 
       CONTAINSSTRING([CombinWords], "Verify")&&
       CONTAINSSTRING([CombinWords], "fail")
       
       )
RETURN
           COUNTROWS(_Result)