How to convert expression compute new account to use at filter panel ?

[Anonymous]

Hi All

I have below expression which compute new account sales amount , working fine :-

NEW ACC =

VAR sales2018_ =

CALCULATE ( SUM ( SALES[sales] ), 'Date'[Year] = 2018 )

VAR sales2019_ =

CALCULATE ( SUM ( SALES[sales] ), 'Date'[Year] = 2019 )

VAR sales2020_ =

CALCULATE ( SUM ( SALES[sales] ), 'Date'[Year] = 2020 )

RETURN

IF (

NOT ISBLANK ( sales2020_ ) && ISBLANK ( sales2019_ )

&& ISBLANK ( sales2018_ )

&& (

SELECTEDVALUE ( 'Date'[Year] ) = 2020

|| NOT ISFILTERED ( 'Date'[Year] )

),

sales2020_

)

The issue i face is because it will never return total amount if i am using straight or pivot table , Because using selected value.

https://community.powerbi.com/t5/Desktop/How-to-make-total-amount-display/m-p/1568207#M638832

Can some one advise how to modify the above expression , so that it is use as filter purpose only. So i can put the Show_New_Acc at filter panel.

https://www.dropbox.com/s/lj8ar9t0nygorbv/PBT_V01029%20ASK.pbix?dl=0

My PBI file at above link.

Paul Yeo

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Hi Ash

wow your expression very powerful. i never excepted.

Thank you very much.

Paul

[Ashish_Mathur]

You are welcome.