Forum Discussion

Gacek014's avatar
Gacek014
Frequent Visitor
3 years ago

Duplicated values in visualised table

I made a visualisation of a table which is related to other table, now I want to create a column in this visualisation with information how many times same name is mentioned in this table. Table can ...
Need Help
Gacek014's avatar
Gacek014
Frequent Visitor
3 years ago

Thanks but I want to have this info in the last column. So I have table like this:

A B C D

x a q 

x s q

x d q

c f q

v g q

And I want to know in column D that x in column A is visible 3 times and c and v only onces.

 

A B C D

x a q 3 

x s q 3

x d q 3

c f q 1

v g q 1

mlsx4's avatar
mlsx4
Memorable Member
3 years ago

Hi Gacek014 

 

Use this:

Medida = CALCULATE(COUNTROWS(MyTable),ALLEXCEPT(MyTable,MyTable[A]))