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 

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous  This is because the SELECTEDVALUE function only works when there's only one value. You need to provide a row context for htis measure. I can't see exactly where the problem is from looking at your measure, but what are you trying to display? This looks more complicated than it needs to be?