Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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! 😊
Solved! Go to 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.
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.
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())
Hi @Anonymous
What is the current dax code of the measure?
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |