Forum Discussion
Solved
Understanding a DAX Measure
Hi Everyone, I wrote a DAX Measure: Count of Unique Colleagues with Compliance Rate = VAR UniqueColleaguesTable = SUMMARIZE( OriginalTable, OriginalTable[Collea...
In your DAX measure, the FILTER function is able to read [Total Compliance Rate] because it is referring to the measure [Total Compliance Rate] that exists in your data model, not the column you created in the SUMMARIZE function.
When you use SUMMARIZE, you are creating a new table with a summarized view of your data, and you can add calculated columns to this table. However, these calculated columns are not directly accessible outside the context of the SUMMARIZE function. Instead, DAX continues to use the measures and columns defined in your data model.
