Countif solution in DAX

[Lars1]

I have some data i would like to present in Power BI but i can't figure it out.
I would like to count how many times an employee or a supervisor appear in my data.

I can do it in Excel with Countif, but i would like to do it in Power Bi.
How to do this ?

 

[RoryA]

Unpivot the data in power query, then it's just a simple row count.

 

[Lars1]

Unpivot the data in power query, then it's just a simple row count.

I am not sure how to do that to get the result i need?

 

[RoryA]

Click Transform Data, select the date column, then right-click and choose Unpivot other columns. You will then have a table with three columns: Date, Attribute, Value (you can rename the last two to something like Role and Name). Wherever you need the count for an employee you can use a simple row count measure.

 

[Lars1]

Click Transform Data, select the date column, then right-click and choose Unpivot other columns. You will then have a table with three columns: Date, Attribute, Value (you can rename the last two to something like Role and Name). Wherever you need the count for an employee you can use a simple row count measure.

Ok. Thank you for your help.
My mistake that i did not specify that the data contains a lot more data i also use.
What i need is a solution where i still got all the rest of the data available and that there is a relation.

 

[RoryA]

Depending on what exactly you are doing, you may need to separate the names into a separate query/table and unpivot them there, with a key to link them back to the original data.

 

[Lars1]

Depending on what exactly you are doing, you may need to separate the names into a separate query/table and unpivot them there, with a key to link them back to the original data

and use the Date as relation between the seperate tables...
Thanks

 

[RoryA]

OK, so create a query that just extracts the columns that were in your original post, then unpivot it as I said before.

 

[RoryA]

Note: depending on how you are using it, you may want to just keep that as a separate query and not link it to the other data, as you will end up with multiple lines for each item if you link them.