Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
i have data like below:
I wrote dax for avg amount:
Avg amount = CALCULATE(AVERAGE(‘table1[Amount]),filter(ALLEXCEPT(table1,table1
[Date],table2[Area])))
How to find total amount 5.31 based on avg amount?
Solved! Go to Solution.
@Anonymous,
You may try a similar way as shown here.
Hi @Anonymous,
Based on your screenshot, you seem to be trying to get the average of average. Example for 4/11, the average is 0.45 and then you want to calculate the average for all the dates.
Create two measures using these:
Avg of Amt = AVERAGE ( 'Table'[Amount] )
Avg of Avg of amt= AVERAGEX ( ALL ( Table[Date] ), [Avg of Amt] ) )
The above formula calculates the sum of the average for each day then divides it by the number of days.
Proud to be a Super User!
@Anonymous,
You may try a similar way as shown here.
Thanks for sharing the link
based on date and area wise average amount is calculated
we can see single date(04/04/2018) amount is 0.05 and average amount 0.05
single date multiple times(04/09/2018) amount is 0.95, 1.5, 1, 0.5 , 0.65 and average amount 0.92
based on the above average amount calculations . Find total average amount : 5.31
can you please assist?
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |