Hi I have matrix visual where I am trying to count rows of columns of table

[izzu]

I have matrix visual where I am trying to count rows of multiple columns for exammple Column A is " Assign to"  Column B "Created By" , Added Assign To Coulmn in Rows of Matrix visual when I am adding "created By"  in Vaules (count) its not shwoing correct count its showing same as Assigned To ,

I tried by created a caluculated column "ColmCreatedBy = if(CONTAINS(Tabel1, Tabel1 [ASSIGN TO NAME], Tabel1[CREATED BY NAME]),1,0)"

and then count the 1 vaule its aslo not shwoing acurate vaules I think am miisng some thing.

[Sahir_Maharaj · Accepted solution]

Hello @izzu,

You can use DISTINCTCOUNT to count the unique occurrences in the "Created By" column:

CountCreatedBy = DISTINCTCOUNT(Table1[CREATED BY NAME])

If you want to count the rows where "Assign To" and "Created By" are different, you can create a calculated measure instead:

CountDifferentAssignToCreatedBy = 
CALCULATE(
    COUNTROWS(Table1),
    Table1[ASSIGN TO NAME] <> Table1[CREATED BY NAME]
)

Hope this helps!