PowerBI see query behind visual
Step 1: Turn on performance analyzer and select the analyze this visual option.
After that, performance analyzer adds some lines:
Click copy query and paste anywhere:
And you see, there is the distinct value on it. Let's add something unique, like the orderID:
These are auto-generated in the background..And we reached the end of this idea.