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,
I currently have this formula:
Solved! Go to Solution.
Hi,
This measure works fine for me
=SUMX(FILTER(SUMMARIZE(VALUES(Data[Account]),Data[Account],"ABCD",SEARCH("Cleaning",[Account],1,-1),"EFGH",SUM(Data[Actual])),[ABCD]>0),[EFGH])
Hope this helps.
Hi,
This measure works fine for me
=SUMX(FILTER(SUMMARIZE(VALUES(Data[Account]),Data[Account],"ABCD",SEARCH("Cleaning",[Account],1,-1),"EFGH",SUM(Data[Actual])),[ABCD]>0),[EFGH])
Hope this helps.
User | Count |
---|---|
84 | |
81 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
105 | |
96 | |
86 | |
68 |