Forum Discussion
Solved
Tricky Dax Measure For Dynamic and Static End Dates
Hi, I cannot seem to find a solution to this! This is quite tricky and complicated as it involves 3 different scenarios with static and dynamic end date. If the cell is blank, use the date fi...
Hi amitchandak. I was close enough. I still have another issue. I have multiple rows of data on of each person. I had tried changing your code:
Count in Bucket 1 = sumx( values('Age Ranges'[Range]) ,CALCULATE(Countx(filter(Employee,[Current Age Buckets] = Max('Age Ranges'[ID]) ),[Current Age]), CROSSFILTER('Date'[Date],Employee[Start Date],None)))
and changed it from Sumx to Countx but I got just a count of all the range which is 3 (because I have 3 rows in the range dimension table).
thank you
and changed it from Sumx to Countx but I got just a count of all the range which is 3 (because I have 3 rows in the range dimension table).
thank you