Forum Discussion

2FG's avatar
2FG
Frequent Visitor
4 years ago

Wrong total value DAX

Hi! Hope someone can help me with this question. BACKGROUND: I have two tables:   Calendar = ADDCOLUMNS ( CALENDAR (DATE(2016,1,1), DATE(YEAR(TODAY())-1,12,31)), "Year", YEAR ( [Date] ))   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi 2FG ,

 

You can get the correct total value by creating a new measure.

 

New measure = SUMX('TableName', [1a Number of respondents (last value)] )

 

Then you put the new measure into it, I'm sure you'll get this.

City

    1a Number of respondents (last value)

New Measure

   Cityname2

    170

170

   Cityname3

    166

166

Total

    170

336

 

Please give it a try.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • 2FG's avatar
    2FG
    Frequent Visitor
    4 years ago

    Hi!

    No, sorry, it doesn't work as long as I have a filter on the year. Then I still get 170 in the total level.