Forum Discussion
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.
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.
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
- foodd
Community Champion
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
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.
