Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
109 | |
94 | |
84 | |
32 | |
27 |