ISFILTERED measure for multiple filters chosen only

[AdamPowerBI2024]

Hi,

I want to create a measure to show a sign only when multiple filters are chosen (5x). I don't really get the result I want. When I choose 3 filters, (Blank) pops up as text, when i choose 4 filters i get the requested text from the formula.

Following formula was used:

Measure =

IF(ISFILTERED('price list upload'[Item Type]),

IF(ISFILTERED('price list upload'[Country]),

IF(ISFILTERED('price list upload'[Item no.]),

IF(ISFILTERED('price list upload'[Route]),

IF(ISFILTERED('price list upload'[Currency]),

UNICHAR(128504),"choose all filters")))))

Can anybody give me a hint what can be wrong?

[Kedar_Pande]

@AdamPowerBI2024 

Try

Measure =
IF(
COUNTROWS(
ALLSELECTED(
'price list upload'[Item Type],
'price list upload'[Country],
'price list upload'[Item no.],
'price list upload'[Route],
'price list upload'[Currency]
)
) = 5,
UNICHAR(128504), 
"choose all filters"
)

This checks if all 5 filters are applied by counting how many fields have been filtered and shows the symbol when the count equals 5. Otherwise, it prompts the user to "choose all filters."

If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande

[AdamPowerBI2024]

Thank you for that. Unfortunately, I still get the "mark all filters" , even if I choose all 5 filters.

[SamWiseOwl · Accepted solution]

Hi @AdamPowerBI2024 

Could you try using && for the AND instead of seperate IF statements

measure =

IF(ISFILTERED('price list upload'[Item Type])

&&ISFILTERED('price list upload'[Country])

&&ISFILTERED('price list upload'[Item no.])

&&ISFILTERED('price list upload'[Route])

&&ISFILTERED('price list upload'[Currency]),

UNICHAR(128504),"choose all filters")

Also on a side note instead of UNICHAR(128504) you can do emoji in quotes "💸"  use Windows + . to see the emoji keyboard in Windows.

[AdamPowerBI2024]

Thank you. This one worked. Kudos!

[SamWiseOwl]

Super! If you could mark it as a solultion for others to find, thank you!