No Filters selected, show default value as 100%

[Anonymous]

Hi Experts

I have the following filters in my report/dashboard

1. ID

2. Country

3. Region

4. File

if no filter is selected and they are showing ALL, i want the default value, to be 100% otherwise when filter is applied measure A.

[kamalmsharma]

Hi,

Can you pls share screenshot or PBI file to visualize the scenario?

Regards,

Kamal

www.addendanalytics.com

[lc_finance · Accepted solution]

Hi @Anonymous ,

You can try the measure below, it should work!

Measure = 
VAR check1 = OR(ISFILTERED(table[ID]),ISFILTERED(table[Country]))
VAR check2 = OR(ISFILTERED(table[Region]),ISFILTERED(table[File]))
VAR totalCheck = OR(check1, check2)

RETURN
IF(totalCheck, [Measure A], 100%)

Regards,

LC

Interested in Power BI finance templates? Check out my blog at www.finance-bi.com

[Anonymous]

Many Thanks LC

works prefect, slight tweak.