Forum Discussion
Total Count Without Duplicates
YES that's right
vishalbaldania change the column to measure and see if it adjusts it properly
ps are you wanting to see the total of all on every row, or only what is related to that row
you also need to check your data because the measure might be correct, if you still struggling you can send me your pbix
if i am not understanding you
detail what you expect to see
As you said i created Measure A and it's works but I can't see the total rows on the bottom. Might be becasue of i used distictcount if i use something else like count or countrows it does not works
vishalbaldania ok but can you tell me what you expect to see there? because i dont quite understand the issue here,what is the expected value at the bottom the total is going to return a distinct count of all equipment ids, it look like you only have one equipment id in your table.
i am not quite sure what you objective is, if you explain the business requirement mabye i can help you better