Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |