table/matrix visual - on each row show number of rows selected in total report

[po]

Hi,

have a report 2 visuals

one a card visual and has

(DISTINCTCOUNT('table'[col]))

shows 6 

and have a table visual which shows the 6 rows.

When try show this (DISTINCTCOUNT('table'[col])) shows as 1 on each row rather than 6 presumably as evaulating at row level rather than shpwing the total in report which 6.

How can we have a variabale which shows this (DISTINCTCOUNT('table'[col])) on each row of the table so evaluate at report leve rather than row level?

Thanks

[amitchandak · Accepted solution]

@po , try one of the two options

calculate(DISTINCTCOUNT('table'[col]), allselected('table'))

or

calculate(DISTINCTCOUNT('table'[col]), all('table'))

[po]

Thanks for response