Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to make total amount display ?

Hi All I have a expression , when i use this for table , it does not able to display the total amount  :- NEW ACC = VAR sales2018_ = CALCULATE ( SUM ( SALES[sales] ), 'Date'[Year] = 2018 ) VAR...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , When you use the selected value, In that case, if 2020 is selected then 2019 and 2018 will be blank as per your formula. In other cases, grand total does not have a year, which you are checking in the formula so, you will not get grand total. What are trying to achieve here 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

is that expression a calculated column, or a measure?  You will want to apply context transforms as needed (for example by including an "ALL()"  filter etc)