Forum Discussion

Helper II

5 years ago

Solved

Display count on card

Hello Experts,

I have a simple query and my requirement is very simple.

Based on that query I need to take a count of account number and display in a card.

I was able to display data set for that query, however not sure how to display count of acct numbers.

I created a card then from my dataset , selected that field and summarized (count) and used on card, however count is not correct.

Thanks

tina345
5 years ago
Hello Parry2k,
It doesn't have any filter.
Based on the table, I am simply summarizing acct_nbr as count distinct and using that value on card.Its displaying as 1 which is not correct.

I even tried creating a measure below, table has around 400 accounts, however its just displaying 1.
count_distinct = DISTINCTCOUNT(Table[ACCT_NBR])
parry2k
5 years ago
tina345 doesn't make any sense? There has to be something. Can you just put this measure in a table visual? I'm sure there is more than 1 unique value for acct_nbr.

There has to be some sort of filter, either page/report level.