Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
@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.
I am really sorry that was my fault on my end.
My page wasn't refreshing properly even if I refreshed.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |