Forum Discussion
Filtering Table based on specific conditions
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)
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) )
1 Reply
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) )