topic Re: Show report only when value is selected from filter pane in DAX Commands and Tips

Show report only when value is selected from filter pane

rob_vander2 — Fri, 10 Jan 2025 16:07:45 GMT

Hi All,

I have one table report column Country and masure sales. I have included same country dimension in in page level filter pane. I want to show this report only when country is is selected from filter pane, otherwise should be blank. I tried with ISFILTERED but it's not working as Dimension is already in filter conetxt of this table visual. How can I achieve this?

Re: Show report only when value is selected from filter pane

Sahir_Maharaj — Fri, 10 Jan 2025 19:24:27 GMT

Hello rob_vander2,

Can you please try this approach:

Show Report = IF( HASONEVALUE('Country'[Country]), CALCULATE( SUM('SalesTable'[Sales]), FILTER( ALL('Country'), 'Country'[Country] IN VALUES('Country'[Country]) ) ), BLANK() )

Re: Show report only when value is selected from filter pane

rob_vander2 — Sat, 11 Jan 2025 19:07:25 GMT

Sahir_Maharaj Thanks for the reply. I have kind of got the solution with below DAX measure and it works. Could you tell me which one will be better?

if( COUNTROWS(ALLSELECTED('Dim_country'[Country])) < COUNTROWS(ALL('Dim_country'[Country])), [Sales Amount],BLANK())

Re: Show report only when value is selected from filter pane

rob_vander2 — Sat, 11 Jan 2025 19:15:21 GMT

Sahir_Maharaj Also, your solution doesn't seem to be working. When I put your DAX in the report, by default I can still see the report for all countries instead of blank

Re: Show report only when value is selected from filter pane

Sahir_Maharaj — Sat, 11 Jan 2025 20:07:17 GMT

Hello rob_vander2,

Thanks for your response.

Can you please try these updated approaches:

Show Report = IF( ISFILTERED('Country'[Country]), [Sales Amount], BLANK() )

IF( HASONEVALUE('Dim_country'[Country]), [Sales Amount], BLANK() )

Re: Show report only when value is selected from filter pane

Anonymous — Mon, 13 Jan 2025 05:07:36 GMT

Hi All,
Firstly Sahir_Maharaj thank you for your solution!

And rob_vander2 ,Since in the screening process, if you do not select any city, the default logic is that you select all cities, so then in this case, we need to add a little restriction to ensure that the logic works properly.

Display Sales @ = IF( CALCULATE(HASONEVALUE('Countries_Table'[Country]),ALLSELECTED('Sales_Table')), SUM('Sales_Table'[SalesAmount]), BLANK() )

If you have further questions, check out the pbix file I uploaded and I would be extremely proud if my solution solves your problem!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Re: Show report only when value is selected from filter pane

rob_vander2 — Wed, 15 Jan 2025 17:01:59 GMT

Anonymous Problem is I should be able to select multiple countries as well. In this case hasonevalue restricting to select only one country

Re: Show report only when value is selected from filter pane

Anonymous — Thu, 16 Jan 2025 03:10:56 GMT

Hi rob_vander2 ,
According to your new requirement, you want to be able to filter multiple cities can also be displayed is it, you can try the following code, hope it can help you!

Display Sales @ = IF( CALCULATE(ISFILTERED('Countries_Table'[Country]),ALLSELECTED('Sales_Table')), SUM('Sales_Table'[SalesAmount]), BLANK() )

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.