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
in the below example Matri table, I want the avg range between 5 to 45. please suggest the formula.
in the below example it includes all column data & generates Avg.
Another example is given below
1 | 13 | 13 |
2 | 15 | 15 |
3 | 21 | 21 |
4 | 21 | 21 |
5 | 28 | 28 |
6 | 48 | |
7 | 93 | |
Avg | 34 | 19.6 |
Regards,
Sameer
Solved! Go to Solution.
Hi, @sameergupta60
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create a measure as below.
Result =
IF(
ISINSCOPE('Table'[Category]),
SUM('Table'[Val]),
AVERAGE('Table'[Val])
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @sameergupta60
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create a measure as below.
Result =
IF(
ISINSCOPE('Table'[Category]),
SUM('Table'[Val]),
AVERAGE('Table'[Val])
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@sameergupta60 , Try like
averageX(filter(table, table[value]>= 5 && table[value]<= 45),table[Value])
User | Count |
---|---|
93 | |
86 | |
78 | |
72 | |
65 |
User | Count |
---|---|
115 | |
106 | |
85 | |
65 | |
64 |