Count values from multiple fields

Anonymous - You can UNION your columns together and then FILTER out the values that match your entry plant name and then COUNTROWS the filtered set.

Your data should be unpivoted in the query editor (highlight the columns not shown, right click and choose Unpivot Other Columns).  Having all your data in a single column will make your analysis much easier (you would still have the Name # in the "Attribute" column for other analysis).

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Anonymous  ,
Can you let me know that Entry planted name are different columns so do you want such results ??

Name   entry planted 1     entry planted 2      entry planted 3

A                 12                           14                            15 
B                   3                             12                          12             
C                    23                            1                              123

Let me know , so that i could help

Anonymous , better to unpivot

https://radacad.com/pivot-and-unpivot-with-power-bi

Or create a join it with a common dimension Entry planned name, all 4, With one active and another inactive. Create 4 count measure with userelation and them

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

How to combine value and create table. example in pbix . you have to do for four column

https://www.dropbox.com/s/op9lb78w9utdonz/Distinct%20from%20two%20Tables.pbix?dl=0

Dear Anonymous ,
I got your question 
https://drive.google.com/file/d/1msJ8bR2IuJfercsDW6D3etuQ70OjHvJZ/view?usp=sharing

go to this link download , it is yur solutiuon 

steps are 
1) You must have a index table with Distinct name 
2)  go in transform data , using home option in your Head ribbon , after going in transform , you will see your table
3)Now select all columns you want to count , then go in transform tab click unpivot selected columns 

3)Then close and apply .

4) Make sure your name from index has relation with values after unpivoting .(using model ribbon on LHS)

5) then just put


Done !!!

Please dont forget to give kudos ,
If it help you reach your solution please accept this post as solution .
if any further doubt please let me know ill be more than happy to help

Thanks 
Sujit