Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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.
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
27 |
User | Count |
---|---|
99 | |
91 | |
51 | |
49 | |
46 |