Forum Discussion
Count entries in custom table
Hallo All, I am trying to count the number of entries on a Date table column, but it should be dynamic in the sense that I am using 3 fields from the date table namely, year, month and day. The p...
Anonymous , I think it should some role of what if selected
some thing like this
measure =
var _Expression=if(ISFILTERED('Date'[Month Year]),values(Date[Month-year]),if(ISFILTERED('Date'[Year]),Values(Date[Year]),Values(Date[Date])))
return
countx(_Expression,Date[Date])Also, other examples where measures have been filtered
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Hi Anonymous,
I'd like to suggest you take a look at below blog about how to handle the different hierarchy levels:
Clever Hierarchy Handling in DAX
Regards,
Xiaoxin Sheng
Thank you for this additional info. I will look at it also.