Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Need help with Count, for data

Hi

 

I have a table called "Devicebreakdown" , from which I need to find out how many were "android users" , "ipad", etc 
How do I go about doing this

 

Thank you 

 

power bi 3.JPG

1 ACCEPTED SOLUTION
AnkitKukreja
Super User
Super User

Hi @Anonymous 

 

Simply create a measure and use distinctcount ( unique_id ) and then in a table visual drag platform and your new measure.

 

Thanks,

Ankit

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

View solution in original post

2 REPLIES 2
AnkitKukreja
Super User
Super User

Hi @Anonymous 

 

Simply create a measure and use distinctcount ( unique_id ) and then in a table visual drag platform and your new measure.

 

Thanks,

Ankit

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
amitchandak
Super User
Super User

@Anonymous , create a visual platform on row take distinctcount of machash or userid, if you have.

 

or take the platform  on slicer and filter for these two take distinct count of machash or userid on card

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.