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
Shishir22's avatar
Shishir22
Icon for Solution Sage rankSolution Sage
4 years ago

Hello 2FG ,

 

Can you try -

TEST =
IF (
    HASONEVALUE ( SURVEY[CITY] ),
    [1a Number of respondents (last value)],
    SUMX ( VALUES ( SURVEY[CITY] ), [1a Number of respondents (last value)] )
)

 

Please Accept it as the solution if it solves your issue. Kudos are also appreciated.

 

Cheers,

Shishir

 

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

Hi Shishir22 , 
Unfortunately that does not work either. With this measure the value for Cityname3 becomes blank and the total is still 170.