Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello comunity,
I have a simple table that looks like this:
delivery | product | price | r price
1011084259 | 10096246 | 37 | 50,7 |
1011085643 | 10096246 | 37 | 44,1 |
1011260543 | 10096246 | 37 | 55,2 |
1011369349 | 10096246 | 37 | 42 |
1011684236 | 10089222 | 25 | 63,7 |
1011675242 | 10096246 | 37 | 46,9 |
1011677098 | 10096246 | 37 | 48,2 |
1011723460 | 10096246 | 37 | 45,2 |
The average of column price is 35,5 = average(table[price])
1011084259 | 10096246 | 37 | 50,7 | 86,2 |
1011085643 | 10096246 | 37 | 44,1 | 79,6 |
1011260543 | 10096246 | 37 | 55,2 | 90,7 |
1011369349 | 10096246 | 37 | 42 | 77,5 |
1011684236 | 10089222 | 25 | 63,7 | 99,2 |
1011675242 | 10096246 | 37 | 46,9 | 82,4 |
1011677098 | 10096246 | 37 | 48,2 | 83,7 |
1011723460 | 10096246 | 37 | 45,2 | 80,7 |
The following measure doesnt work...it sums each price to r price per row.
Solved! Go to Solution.
Hey,
Try this:
r price + average =
VAR r_price =
SUM ( 'table'[r price] )
VAR r_price_average =
CALCULATE ( AVERAGE ( 'table'[r price] ), ALLSELECTED () )
RETURN
r_price + r_price_average
Hi @Pillic
You can do the following
r price + average price =
VAR AveragePrice =
CALCULATE ( AVERAGE ( Data[price] ), ALLSELECTED ( ) )
RETURN
SUMX (
Data,
Data[r price] + AveragePrice
)
Hi @tamerj1 ,
thanks, this provided measure is much faster if I use it with unfiltered content. Awesome. Thx
Hey,
Try this:
r price + average =
VAR r_price =
SUM ( 'table'[r price] )
VAR r_price_average =
CALCULATE ( AVERAGE ( 'table'[r price] ), ALLSELECTED () )
RETURN
r_price + r_price_average
Hello Barthel,
amazing that did the job. I needed to change it a bit like this:
r price + average =
VAR r_price =
SUM ( 'table'[r price] )
VAR price_average =
CALCULATE ( AVERAGE ( 'table'[price] ), ALLSELECTED () )
RETURN
r_price + r_price_average
Thanks a ton for this fast response...Yall have a nice weekend, as I will now.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |