Regulating a calculated measure by number of responses

[agalbraith]

I know it has been asked before that you cannot put a filter for response count on a card because a card is simply a measured calculation. But is there really no other work around or way to visualize such a thing in power bi overall? It seems like such an oversight in the program. Calculating an average based on the respondents in that data table is possible, yet we can't then make sure it only calculates for respondents greater than 5 or 10. The issue is when slicers pn the page are applied, then we get below the threshold of 5 we want to display within those certain slicer categories. Is there a different visual to use or work around for this? 

[agalbraith · Accepted solution]

For anyone looking, I have found a solution to this via another help community. There are three things that must be done in order to filter the calculated measure by the count of responses:

1) Calculate your measure (whether it's an average, average x, division, multiplication, etc)

2) Calculate a count measure for the table using COUNTROWS

3) Calculate an IF measure using both the measure and the count measure within it as follows: 

CountIF = IF (Table [Name of count measure]>=5, Table[Name of calculated measure], BLANK() )

This third calculation is what you would display in a card or a bar chart. It will return all values under 5 responses as Blank and anything 5 or greater as the calculated measure.

It can be adjusted to just >5, >10 without the equals as well I just needed >= for my purposes. I realize it says >5 in the calculation but it behaves the opposite. When you type <5 it rather blanks all the numbers above 5 and only displays the ones below 5. I do not know the reason why it behaves opposite the symbol (I am not an expert in this program), but I just know that this has now been the solution to my needs!

I have a file example with dummy variables, but unfortunately do not see a place to attach a file.

[Greg_Deckler]

@agalbraith Just include the filter logic in your measure like:

Measure = CALCULATE(AVERAGE('Table'[Column]), [Column1] > 5)

[agalbraith]

Sorry I should also point out it's a weighted average. Could I do the same?

Would it look like this:

AVERAGEX(Table, Table[Value] >5)

[agalbraith]

sorry forgot to at you @Greg_Deckler . I tried the weighted average with the >5 and that didn't work how I had it written

[Greg_Deckler]

@agalbraith Is the weighted average a measure? If so, wrap your filter parameter in FILTER.

[agalbraith]

@Greg_Deckler yes it's a measure. Can you give me an example of how I would write the dax with the FILTER command?

[Greg_Deckler]

@agalbraith Measure = CALCULATE(AVERAGE('Table'[Column]), FILTER([Measure] > 5))