Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to average the column CONFIABILIDAD [column calculadted: New Measure] (Picture 2) excluding the column META (Picture 1). The formula DAX (Picture 4) that I am using is averaging everything (it is not excluding the column META) and the "wrong" result is 81.83% (Picture 3). The correct answer should be 96.67%. I appreciate the help
Solved! Go to Solution.
Please try something like below, using filter to exclude product not required.
Measure 7 = AVERAGEX(KEEPFILTERS(filter(values('Product'[Category]),'Product'[Category] <> "Bikes")),CALCULATE([Measure 5]))
Regards,
AJ
Do Like Post if response seems good and Worth liking.
Do Mark as Solution if response resolved your Issue.
Actaully, Didn't get time to add few things yesterday.
1) You don't need KeepFilters here. As per PBI Docs, KeepFilter is only required with Calculate and CalculateTable to keep context from changing.
2) When using a Measure inside Aggregate function, you don't need to add Calculate function. Don't have an exact theory however as per my understanding, using Measure an internal/default Calculate is automatically added.
Regards
AJ
Please try something like below, using filter to exclude product not required.
Measure 7 = AVERAGEX(KEEPFILTERS(filter(values('Product'[Category]),'Product'[Category] <> "Bikes")),CALCULATE([Measure 5]))
Regards,
AJ
Do Like Post if response seems good and Worth liking.
Do Mark as Solution if response resolved your Issue.
Actaully, Didn't get time to add few things yesterday.
1) You don't need KeepFilters here. As per PBI Docs, KeepFilter is only required with Calculate and CalculateTable to keep context from changing.
2) When using a Measure inside Aggregate function, you don't need to add Calculate function. Don't have an exact theory however as per my understanding, using Measure an internal/default Calculate is automatically added.
Regards
AJ
Thanks AnkitBI,
I did it without using KeepFilters and it worked perfectly. Very thankful
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |