Only show selection values

[ahmd]

Hi,

I have 3 dimensions (Dim1, Dim2, Date) and Sales.

I want to show the sales only according to Dimension Selection otherwise Sales should be null in the text object.

Scenario 1: If there is no selection then the text object shouldn't show any sales

Scenario 2: If I select Dim 1, Dim 2 then it must show me the latest day sales.

Scenario 3: If I select Dim 1, Dim 2, Date Dimension then it must show me the sales according to selection.

Dim 1	Dim 2	Date	Sales
A	A1	12.01.2021	101
A	A2	11.01.2021	102
B	B1	12.01.2021	201
B	B2	11.01.2021	202
B	B3	10.01.2021	203
C	C1	12.01.2021	301
C	C2	11.01.2021	302
C	C3	10.01.2021	303
C	C4	09.01.2021	304
C	C5	08.01.2021	305

[MayilVahanan]

HI @ahmd 

Try like below

=If(GetSelectedCount([Dim 1])+GetselectedCount([Dim 2]) >=1, Sum({<Date={"$(=Date(Max(Date),'DD.MM.YYYY'))"}>}Sales), null())