Forum Discussion
Card Count not providing the correct count
I'm new to Power Bi, and I'm trying to create reports for my managers that are easily readable for tracking the amount of work open and processed. When I use a card to get a count, I'm getting numbe...
Anonymouscolumn you counting is ECN Ref (based on card visual), does it have blank? Can you create measure like below and use that measure on the card.
Cnt = COUNTROWS( Table )
Are you using count or distinctcount?
I've tried it with both.
Are you using a measure or counting a field in you dataset?
I'm counting a field in my dataset.
I found a way to make it work, but it's a work-around not a solution, I created a new column in my dataset, using only the year, and then counted that and received the correct number.
Anonymous wrote:Are you using a measure or counting a field in you dataset?
Anonymouscolumn you counting is ECN Ref (based on card visual), does it have blank? Can you create measure like below and use that measure on the card.
Cnt = COUNTROWS( Table )