Count and % of a total for individual parts.

[64653463456greg]

So, I have around two hundred parts with individual serial numbers that I want to extract data from. All in one big file. The picture shows a small snipped of the almost 1 million rows I have at my disposal.

Each Part (serial #) have been operational up to 20,000 times and have been running for a specific number of minutes each time.

What I want to know is how can I extract the number of times the part has been running below a certain number of minutes or between a certain number of minutes.

So, let’s say the part has been used 8,000 times, how many of those times was the part in use below 60 minutes, or between 30 and 60 minutes.

And if possible, also show that as a percentage if I would want.

Any help is greatly appreciated as I am a complete beginner when it comes to Power BI.

[ribisht17 · Accepted solution]

@64653463456greg 

CONDITION THAT I HAVE GIVEN IS MORE THAN 50 MINS

Step 1

Threshold = IF(Threshold[Minutes]>50,1,0)

Step 2

OverAll Count within Serial = CALCULATE(COUNTROWS(Threshold),FILTER(all(Threshold),Threshold[Serial]=EARLIER(Threshold[Serial])))

Step 3

Total = CALCULATE(SUMX(Threshold,Threshold[Threshold]), FILTER(all(Threshold),Threshold[Serial]=EARLIER(Threshold[Serial])))

% of Total = DIVIDE(Threshold[Total],Threshold[OverAll Count within Serial]) * 100

Regards,

Ritesh

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[64653463456greg]

Thank you very much Ritesh!

I really appreciate it!