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.
Input Table
Output
Hi everyone,
I have a input table with ID . i need a measure which calculates average of due days foe each Id. In this example my output should be 25. It should sum up the due dates for each ID and then calculate average.when i have a slicer for ID and if i take a single ID it must show sum of due dates(ID 110=15, ID 112=30)
I have tried the following measure
1)m1= averagex(summarize(fi,fi[ID],fi[Due Days]),fi[Due Days])
2)m2=calculate(average(fi[Due Days]),distinct(fi[ID]))
Also note that i am using this measure in a card visual and if i have a slicer for ID, IF i filter by ID=110 the output should be 15(10+5)
Solved! Go to Solution.
Hi @Anonymous what is your desired result?
Hi @Anonymous what is your desired result?
25 is desired result, Lets say you add this measure to a card visual, you have a slicer for ID you select an ID 110 it should display 15(10+5).
@Anonymous yes it work
Create a dimension table containing all the unique IDs.
Join it to this table shown
remove the ID shown and replace with the ID from the dim table.
then write a measure
AVERAGEX(NewDimTable,calculate(sum(originalTable[due days])))
@MattAllington like i said i need this for a card visual so will this method work, is there a way we could achieve the same functionality with a measure?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |