DAX Measure to calculate column records in a matrix table

[pg9]

Hi All,

I have pivoted few columns and created a dynamic matrix table with details mapped to Employee IDs in the dataset.

However, I'm looking to count the number of records in the employee ID column alone. 

Can someone suggest a dax measure to calculate the number of records for an individual column for the dynamic table please?

[pg9]

Hi @Amit 

Please find the scenario below,

I have a slicer as shown below

The output table changes as when I make selections on the slicer

Step 1 : When i choose one field, it gives me the below total count

Step 2 : When i start choosing extra columns, the count keeps doubling as below,

Requirement : I want to count the rows for only the EMPLID field alone and do not want the row count to change when I change the selections.

Can you help me with a DAX measure for this please?

[amitchandak]

@pg9 , a measure like below should do

cnt = count(Table[Employee ID])

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.