how to get multi result

[Bruce_Fei]

Hi

I have data source like below:

Data source

I load to powerBi and create four new measures:

Total_AssQty = Sum(AssQty)

Total_FailQty = Sum(FailQty)

FPY = 1-Divide(Total_FailQty,Total_AssQty)

RTY = Productx(tablename,FPY)

I get the FPY result and RTY result are below:

the RTY logic is, for example P1's RTY = 1*0.944*1*0.95*0.95*1(FPY of XTA-Ass*FPY of XTA-Co*FPY of XTA-NV*FPY of XTA-OF*FPY of XTA-T*FPY of XTA-VR);

but with the RTY measure i get the wrong result, how could i get my expected result?

thanks.

[harshnathani]

Hi @Bruce_Fei ,

You measure should be working.

Try this

RTY =
PRODUCTX (
    VALUES(tablename[Product]),
    FPY
)

Regards,
Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[Bruce_Fei]

Hi @harshnathani 

i get the message: Too many arguments were passed to the VALUES function. The maximum argument count for the function is 1.

this measures can't be used.

thanks.

[harshnathani]

HI @Bruce_Fei 

RTY =
PRODUCTX (
    VALUES(tablename[Product]),
    FPY
)

tablename = Name of your Table

Product = Column in the table Table tablename

FPY = Measure which was created.

 Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Bruce_Fei]

Hi, @harshnathani 

I copy your formula format, then it works. my formula format is RTY = Productx(Values(tablename[Product],FPY))

why should that format?

and the RTY reslut still not correct, now the RTY for P1 is 0.98, the correct result should be 0.85.

i checked, 1-Total_FailQty/Total_AssQty is 0.98 for P1. 

thanks.

[harshnathani]

Hi @Bruce_Fei ,

pls share sample data in text format.

Upload it on Onedrive or GDrive and share.

Regards,

Harsh Nathani

[Bruce_Fei]

Product	Workstation	AssQty	FailQty	Date
P1	XTA-Ass	7		2020-06-16
P1	XTA-Co	6		2020-06-16
P1	XTA-OF	6	1	2020-06-16
P1	XTA-T	7		2020-06-16
P1	XTA-NV	7		2020-06-16
P1	XTA-Ass	8		2020-06-17
P1	XTA-OF	8		2020-06-17
P1	XTA-Co	6		2020-06-17
P1	XTA-T	7	1	2020-06-17
P1	XTA-VR	7		2020-06-17
P1	XTA-Ass	9		2020-06-18
P1	XTA-NV	7		2020-06-17
P1	XTA-OF	8		2020-06-18
P1	XTA-Co	6	1	2020-06-18
P1	XTA-T	7		2020-06-18
P1	XTA-VR	7		2020-06-18
P1	XTA-NV	7		2020-06-18
P2	XTA-Ass	16		2020-06-16
P2	XTA-OF	15		2020-06-16
P2	XTA-T	20	8	2020-06-16
P2	XTA-VR	12		2020-06-16
P2	XTA-VR	7		2020-06-17
P2	XTA-T	16	5	2020-06-17
P2	XTA-Ass	10		2020-06-17
P2	XTA-OF	9		2020-06-17
P2	XTA-Ass	19		2020-06-19
P2	XTA-OF	15		2020-06-19
P2	XTA-T	12	7	2020-06-19
P2	XTA-VR	4		2020-06-19
P2	XTA-Ass	2		2020-06-18
P2	XTA-OF	1		2020-06-18
P2	XTA-VR	12		2020-06-18
P2	XTA-T	12	2	2020-06-18

[harshnathani · Accepted solution]

Hi @Bruce_Fei 

Try this measure

RTY =
PRODUCTX (
    FILTER (
        ALL (
            tablename[Product],
            tablename[Workstation]
        ),
        tablename[Product]
            = MAX ( 'tablename'[Product] )
    ),
    ROUND (
        [FPY],
        2
    )
)

Regards,

Harsh Nathani

[Bruce_Fei]

Hi, @harshnathani  

thanks for your help. i get the expected result.