Forum Discussion
Solved
Filter a Distinctcount function by another measure
Hello, i need a measure that calculated the distinct count of Items, but only for the months January and December. So it should just distinct count the items where the Measure i already wrote is ...
Distinct count Jan Dec = CALCULATE ( DISTINCTCOUNT ( 'Table'[Column] ), FILTER ( VALUES ( 'Table'[Column] ), NOT ISBLANK ( [My Measure] ) ) )If column is enough to correctly identify the row and produce the value for the measure then this should work. If additional columns are needed in the filter context then you can replace VALUES with a SUMMARIZE statement including all necessary rows.
this doesn´t work because the item Table is not connected to the Date table, i need to filter it by the measure but i don´t know how
Distinct count Jan Dec =
CALCULATE (
DISTINCTCOUNT ( 'Table'[Column] ),
FILTER ( VALUES ( 'Table'[Column] ), NOT ISBLANK ( [My Measure] ) )
)
If column is enough to correctly identify the row and produce the value for the measure then this should work. If additional columns are needed in the filter context then you can replace VALUES with a SUMMARIZE statement including all necessary rows.