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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors