Forum Discussion
oliverblane72
5 years agoFrequent Visitor
Cumulative Distinct Count by Day Behaving Incorrectly with Filters
Hi there, I am trying to plot a cumulative distinct count graph of IDs from this table: I used the following DAX code to generate a cumulative distinct count table by date: CumTable = SELECT...
- Anonymous5 years ago
// Please create a proper calendar in your // model following the guidelines outlined here: // https://dax.guide/dateadd // and connect it to your fact table and remember // that fact tables should always be hidden and // slicing should only happen via dimensions. If // you want to get into trouble, ignore the rule. // // Then you can write: [# Distinct ID to Date] = var CurrentDate = MAX( Dates[Date] ) return CALCULATE( DISTINCTCOUNT( 'Learner Info Daily'[LRN] ), KEEPFILTERS( Dates[Date] <= CurrentDate ), ALLSELECTED( Dates ) )
Anonymous
5 years agoNot applicable
Calculated tables are STATIC. Once calculated, they never change. You need a measure, not a table.
- oliverblane725 years agoFrequent Visitor
Right, I see! Thank you, Daxer.