understanding
1 Topic
Understanding a DAX Measure
Hi Everyone, I wrote a DAX Measure: Count of Unique Colleagues with Compliance Rate = VAR UniqueColleaguesTable = SUMMARIZE( OriginalTable, OriginalTable[Colleague], "ComplianceRate", [Total Compliance Rate] ) I first performed a summarize because the data includes colleagues name repeating many time. VAR FilteredTable = FILTER( UniqueColleaguesTable, AND([Total Compliance Rate] >= 0.5, [Total Compliance Rate] < 1) ) I then performed a filter on the siummairzed table, to get the compliance rate for each colleague RETURN COUNTROWS(FilteredTable) I then performed a countrows to get the count of employees that are compliant or not. Question: I wanted to understand why the Filter formula was able to read off [Total Compliance Rate] instead of [Compliance Rate] as I had renamed the column to that in the previous variable (UniqueColleaguesTable).Solved823Views0likes4Comments