Show blank card till a slicer is selected

[Rubal]

Hi All,

Need help with the below scenario.

I have a Spend Measure which is visualised in a card. The measure is calculated from two tables. Freight Summary Table has Into restaurant price and Consolidated Spend has Vol in Cases.  Price X Volume = Spend is the formula. Both tables is joined by "Country" field which is set as the slicer. I want the card to be blank until I select a country from the slicer.

Spend Measure = SUMX('Freight Summary','Freight Summary'[Into Restaurant Price]* RELATED('Consolidated Spend'[Vol in Cases]))

Appreciate the help.

[Fowmy · Accepted solution]

@Rubal 


Try:

Spend Measure = 
IF( HASONEVALUE('Consolidated Spend'[Country]),
    SUMX('Freight Summary','Freight Summary'[Into Restaurant Price]* RELATED('Consolidated Spend'[Vol in Cases])),
    BLANK()
)

 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Rubal]

It's Magic. Thank you so much @Fowmy Works like a dream.

[amitchandak]

@Rubal , Something like this

if(isfiltered(Country[Country]),[Spend Measure], blank())

[Rubal]

Hi Amit,

Thanks for the prompt response. Why do we have (Country[Country]). Shouldnt it be (table name[Column])?