Forum Discussion
Pikachu-Power
Impactful Individual
Impactful Individualmeasure relative value dont work
Hi all, i have the following dax code where i try to calculate a relative value in a table: Measure_count_entry_relative:
VAR CurrentCount = CALCULATE(COUNT(MEMBER[ENTRYDATE]),
...
One way it seems to work. When i create a new table
FILTER( MEMBER, YEAR(MEMBER[ENTRYDATE]) = YEAR(MEMBER[date_endofmonth]) && MONTH(MEMBER[ENTRYDATE]) = MONTH(MEMBER[date_endofmonth])and remove this part from the measure than i get the right values. So the error must be here somewhere.
Pikachu-PowerImpactful Individual
Impactful IndividualOne way it seems to work. When i create a new table
FILTER(
MEMBER, YEAR(MEMBER[ENTRYDATE]) = YEAR(MEMBER[date_endofmonth]) &&
MONTH(MEMBER[ENTRYDATE]) = MONTH(MEMBER[date_endofmonth])
and remove this part from the measure than i get the right values. So the error must be here somewhere.