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 All - I have issue with a measure created to calculate count using SUMX function. My requirement is to calculate count of document #'s where type = "TP1". But the measure I created returns incorrect values. It seems to be multiplication of Count (Sum of Count where type = TP1) with total count (Count of Doc #). In additional I also need to calculate distinct count for doc #, CC and Year combination. Please help check this. I am also giving a link of PBIX file here. SUMX Count Issue.zip
Formula in the measure =
Thanks,
Phani
Solved! Go to Solution.
In additional I also need to calculate distinct count for doc #, CC and Year combination.
In additional I also need to calculate distinct count for doc #, CC and Year combination.
You can use a table visual for that
When you use the count inside the SUMX you are multiplying each row's filtered count with each row's unfiltered count.
If you need to use SUMX, use
User | Count |
---|---|
88 | |
88 | |
75 | |
67 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |