Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I created a table in my file (see file in link below) and would like to have it filtered based on specific conditions. I would like it so that it only displays when the absolute total of "Average % Difference" for each day is greater or equal to .01 OR if the "Abs Average % Difference" is greater or equal to .01. If it doesn't fit these criteria, I want the value hidden/blank. I put pictures of the table sbefore and after my ideal filtering. I'm sure it's a calculation, but not sure what I would do. Please help!
BEFORE FILTERING
IDEAL FILTERING (what I'm looking for)
Solved! Go to Solution.
@ok_kpop , Create a new measure using measure Average % Difference like
if([Average % Difference]>=.01 , [Average % Difference], blank())
or
calculate([Average % Difference], filter(values(Table[Day]), [Average % Difference] >=0.01) )
@ok_kpop , Create a new measure using measure Average % Difference like
if([Average % Difference]>=.01 , [Average % Difference], blank())
or
calculate([Average % Difference], filter(values(Table[Day]), [Average % Difference] >=0.01) )
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 104 | |
| 81 | |
| 66 | |
| 50 | |
| 45 |