cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ansona Frequent Visitor
Frequent Visitor

Multiply

Hello,

 

i'm new user of power BI, hope someone can answer my question below.

Refer to below print screen, i got OEE result from different department.

now i want to create another chart show OEE of plant performance, which i need 70.8% (BM OEE) * 101.4% (PRT OEE) * 145.8%(EXT OEE). the result should be 104.7%

 

appreciate if someone can anwer me, thanks.

 

 OEE.PNGBM OEE.PNGim using filters function to filter different department resultPRT OEE.PNGFormula or OEE.PNG

 

 

 

 

 

 

 

 

 

 

5 REPLIES 5
silolondon Regular Visitor
Regular Visitor

Re: Multiply

What are the sources of the three OEE percentages?  Are they Calculated Measures? or are they from a data set?

Moderator v-qiuyu-msft
Moderator

Re: Multiply

Hi @ansona,

 

In your scenario, please create three measures which return OEE performance for different department like below:

 

measure for BM OEE= CALCULATE( sum([ERR1%])* sum([OEE SCRAP%])*sum(Plan[UPTI%]),FILTER('Plan',[Machine]="BM"))

 

Then create a new measure to return multiply value from those three measures.

 

Reference:
CALCULATE Function (DAX)

FILTER Function (DAX)

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ansona Frequent Visitor
Frequent Visitor

Re: Multiply

Hi Qiuyun,

 

measure for BM OEE= CALCULATE( sum([ERR1%])* sum([OEE SCRAP%])*sum(Plan[UPTI%]),FILTER('Plan',[Machine]="BM"))

 

if i want to filter more than 1 criteria, how to write that formula?

i want to filter machine BM#1, BM#2, BM#3

 

Thanks

Anson

ansona Frequent Visitor
Frequent Visitor

Re: Multiply

those are calculated measures from data set.

Moderator v-qiuyu-msft
Moderator

Re: Multiply

Hi @ansona,

 

You can change filer parameter value as different BM values in FILTER() function like this:

measure for BM OEE= CALCULATE( sum([ERR1%])* sum([OEE SCRAP%])*sum(Plan[UPTI%]),FILTER('Plan',[Machine]=​"BM#1"))

 

Also you can specify the measure like below:

measure for BM OEE= CALCULATE( sum([ERR1%])* sum([OEE SCRAP%])*sum(Plan[UPTI%]))

 

Then add the field which contains BM#1, BM#2, BM#3 in a slicer for user to check.

 

Best Regards,

Qiuyun Yu

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)