I’m having difficulty calculating the year month count in a filtered period with the additional check that a measure is not blank in that period.
This is the logic that I approached my calculation but for some reason that returns
all selected expects a table reference for argument ‘1’, but a table expression was used
iMonthCount = SUMX ( ALLSELECTED ( VALUES ( tMasterCalendar[YearMonth] ) ); IF ( NOT ( ISBLANK ( [IN] ) ); 1; 0 ) )
1.Why it doesn’t work?
2.How would you approach it?