Forum Discussion
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...
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
amitchandak
Super User
Super UserAnonymous , 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
Hi All
Thank you very one for feedback. look like it is not possible to display total new account sales amount.
Paul