Count different items from different columns

Hi  ViniciusLeyro  

You can use the split by column function to cleanse the data. Please see the following approach:

your data:

Select the first column and do ths split with advanced option = Rows

Firwst result

now do the same again with the other two columns. Then you will have a clean table with all combinations

For the first two questions you can build now a measure with DISTINCT

ADDON

in the end I have seen that I have duplicates in the visual so do cleanse please also do a trim on the columns as a last steps in power query before loading into data model

then it should be fine and not with the duplicates in the visual like above

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.