cancel
Showing results for
Did you mean:
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.

im using filters function to filter different department result

5 REPLIES 5
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

## 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)

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.
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

Frequent Visitor

## Re: Multiply

those are calculated measures from data set.

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.

Announcements

#### 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

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

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)