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.
Hi all
I've been trying hard to get this sum correct but still not able.
The dax measure called count if is not returning me the right sum in the matrix below:
The statement is simple in that count if, if the % is >=1% return 1 else 0. That works well, the problem is the total. In the example above is giving me 8, but it should be 2.
Any support is appreciated. I attach pbix and excel with raw data and outcome desired.
Thanks
Solved! Go to Solution.
Hi @lbendlin
The image is cut, can you please paste the dax?
So far I have:
Count IF =
COUNTROWS(
FILTER(
ADDCOLUMNS(
SUMMARIZE(
Template, Template[Facet], Template[Area], Template[Tier 1: Process Facet], Template[Tier 2: Activity Facet]),"S",[Non Duplicate Hours Process/Activity 3])
))
Thanks.
i added the pbix too.
User | Count |
---|---|
85 | |
75 | |
70 | |
69 | |
55 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |