Only show selection values

ahmd — Wed, 12 May 2021 09:20:35 GMT

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.

Re: Only show selection values

MayilVahanan — Wed, 12 May 2021 09:56:31 GMT

Try like below

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