Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Eduardo_Onchi
Regular Visitor

Count times a value was the selection's average value

I want to make a dynamic evaluation in which I want to know how many times a value was the average of the selection in a range of dates.

These are the average values of each date in my database. Which are the appearances I'm trying to count.

Eduardo_Onchi_0-1689964242525.png

As instance, 38.00 was the average value in 4 different dates.

 

However, when I try to make a count of these appearances they give me way more different dates in which they have appeared. This happens because such value appears in more dates for different rows, despite it not being the average global value of a specified date. As instance, 38 .00 was the value of multiple rows in 25 different dates, but not the global average of the selection.

Eduardo_Onchi_1-1689964352522.png

I could count how many times the price has been the average of the grand total with a column, but I want it to be dynamic for different selections. How can I count the times each value has been the total average of a particular selection?

1 REPLY 1
foodd
Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).


https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...


Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

 

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors