Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

Filter a regular column value in a card visual for showing blank when less than 5 respondents

  • 1.  Filter a regular column value in a card visual for showing blank when less than 5 respondents

    Posted Apr 25, 2022 09:37 AM
    Recently I was able to figure out with the help of this forum how to filter a measure with another measure using the IF function to display blank if there were less than 5 respondents.
    I created a count measure of the variable then use the IF to say that if the count measure was less than 5 then make this other measure not display, aka BLANK().

    How would I accomplish this same thing but apply the count measure to a regular column? Reason being, the column variable is just being placed in a card and selecting to display the average of that column or the median, so there is no second measure to use with the IF function. It seems to only work when there's measures involved for the 'result if true' and 'result if false'. Any ideas?

    ------------------------------
    Angelena Galbraith
    18017
    ------------------------------