Counter when applying the filter

[Anonymous]

Good morning, I hope you can help me,

I want it to tell me the values ​​of the users when applying the filter Contratro, that is, it tells me the values ​​that are when applying the filter

I want 3 to appear, that is, the total that exists when selecting the filter instead of 1

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

1. Create measure.

Measure =
var _select=SELECTEDVALUE('Table1'[Contratro])
return
COUNTX(FILTER(ALL(Table1),'Table1'[Contratro]=_select),[NOMBER USUARIO])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Anonymous , Not very clear

You can do with help from a visual table column

countrows(summarize(Table, Table[Col1] Table[Col2], "_mes", [measure]) )

[Anonymous]

@amitchandak countrows(summarize(Table, Table[Col1] Table[Col2], "_mes", [measure]) )

What would be the last part that is mes", [measure]) )

Pda: They are two tables that are related