Display count on card

[tina345]

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 · Accepted solution]

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 · Accepted solution]

@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. 

[tina345]

I am really sorry that was my fault on my end.

My page wasn't refreshing properly even if I refreshed.

[parry2k]

@tina345 when you say it is not correct what does that mean? How you are comparing it? Do you have a filter on the report?

[tina345 · Accepted solution]

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])