Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |