Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
Hi,
Can you pls share screenshot or PBI file to visualize the scenario?
Regards,
Kamal
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
Many Thanks LC
works prefect, slight tweak.
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |