Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Problem with visual level filtering on card

I've tried to set a visual level filter on a card twice this morning and encountered a problem.   The first time, the card was displaying a count of values in a column. The values were numbers. I t...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi Anonymous,

     

    As the Card dispalys only one value which has been aggregated always, we are not able to add a filter condition based on this aggregate value ("Average of Values"). When the specified fields under Visual level filters pane contain more than one value, then we can set filter condition like yellow highlighted section via Advanced filtering. Take a look at this article: How to use report filters.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-qiuyu-msft,

 

I have a simple card that is running a headcount. It will be filtered eventually by various slicers (demographic data). I need to filter the card to display a count only when that count is >= 10 due to federal reporting laws. Is this possible? I can't think of a way to write a measure as such, and can't filter the card this way. I also have tried this as a table and am having the same issue.

 

Thank you!

-Katy

Anonymous's avatar
Anonymous
Not applicable
8 years ago

What did you try for your measure? Would something like this work in the card instead?

 

(haven't tried it so there may be a syntax error)

 

HC Card Measure  = IF([Headcount] >= 10, [Headcount], "NA")
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

     

    My headcounts are all variations of:

    CALCULATE(COUNT('2017_BSI_MATH'[STUDENT_ID]))

    In some cases, I also use a filter based on another binary field. Below is an example of both a card and table that I am attempting to set a minimum value for (minimum would be based on the overall headcount, not the filtered one).