Default value in card when two or more months are selected on a filter

[Anonymous]

Hello everyone! I would like some help with the following situation.

I have a filter of months and a card with percentages. When a month is selected, the card works perfectly and shows the percentage for the month.

However, when all or more than one month is selected, the card shows the total percentage sum or the sum of the selected months on the percentage card.

I would like that only when two or more months are selected, the card shows the average of the percentage column.

How can I do this?  Thank you very much in advance! 😊

[v-jingzhang · Accepted solution]

Hi @Anonymous 

If the percentage is a column from the table, after adding it to the card visual, you can switch the aggregation type to Average by right-clicking on the column in Fields well and select Average. By default it selects Sum. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Jeanxyz]

I would create a measure including var,

measure_card=

var month_count=distinctcount(dim_date[yearmonth])

return

if(month_count>1, calculate(average(table[Percentage]), blank())

[tamerj1]

Hi @Anonymous 

What is the current dax code of the measure?