Forum Discussion
Remove Duplicates?
Below are my power bi sample. I am asked to create a dashboard to present the stat of left orders. For examples, i do a calculation: orders= calculate(count(ID)). The result shows there are 5 orders....
This makes sense, now I understand.
To count the Orders just use distinctcount('yourtable'[ID]). To answer your other questions it would be really helpful if you would prepare sample data, and make this data available. This makes it a lot easier for all of us to provide answers to your questions.
Cheers
u can create same tables as screenshot in your power bi. Due to P&C, i cant show u the real dataset.