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
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.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
