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.
need help with DAX and Filters... i think. My current formula is calculating on the entire table... i need it by row,
Solved! Go to Solution.
@Anonymous You might try AVERAGEX(FILTER(ALLEXCEPT(...),[Daily Average]<>0),[Daily Average])
@Anonymous You might try AVERAGEX(FILTER(ALLEXCEPT(...),[Daily Average]<>0),[Daily Average])
Nope... i probably have the syntax wrong
it is not iterating per row?
it helps if i have the right relationship set up!
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
13 |
User | Count |
---|---|
102 | |
55 | |
28 | |
19 | |
14 |