Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
1 year ago
Solved

measure 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]), ...
Need Help
  • Pikachu-Power's avatar
    Pikachu-Power
    1 year ago

    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-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
1 year ago

Still 100% when i use REMOVEFILTERS. No change. I work with real data and no dummy data.

 

The years in the column come from the calender table which is connected with MEMBER[ENTRYDATE]. I dont know if there is maybe a problem.