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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jhaswe
Regular Visitor

Distinct machine count altered by filters

I have a table which contains for each date, for each site, a list of machines identified by their manufacturer, their type, their style and machine ID and a sales number they acrew each day.

 

I want to calculate a distinct count of these machines based on their Machine ID. which is distinct to each site but can be duplicated across the sites. So both site and machine ID columns act as the primary key but i want to be able to group the figures up to the different levels e.g. Manufacturer, type and style. 

 

Based on the filters on the page. E.g. it could be filtered to all sites and 1 calendar year, I want the distinct count to summarize this range and change if these filters change e.g. I look at one site, it will show the breakdown of count of machines for each manufacturer for the site ONLY or I want to look at a specific manufacturer and type but only over 6 months. I want the count of distinct Machine IDs for the manufacturer over that date range.

 

I basically want to be able to view the total machines across the estate at different breakdowns and different periods dynamically. Can anyone help? As when i try to average, sum or count distinct it does it on a day level and broken down by the subtypes(type and style) not the total amount of distinct machines for that manufacturer.

2 REPLIES 2
TomMartens
Super User
Super User

Hey,

 

and welcome to this forum, it would be helpful if you create a pbix file that contains sample data, upload this file to onedrive or dropbox and share the link to the file.

 

From the description of you problem, i'm wondering if the same machine (machineid) can be on different sites at the same time.

 

Regards

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi

Will do asap but i need to anonomise it.

 

Yes the machineID Can be used in more than one site. E.g. 01 can be at say Aberdeen and Edinbourgh.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.