Urgent Help wanted for having the right dax queries!!

[koningii]

I want to show:

1) Results that are defined by Approved:  contains only 1 component and has Result of max  0.02

2) Results that are defined by Not approved: contains more then 1 component has has Results > 0.02

3) Table (see below nr 2)

I tried different ways in DAX but cannot come to the right dax queries for all 3.

The data set

Sample code         Master Product           Component         

A                           PERU                            X .                         

B                           PERU                            X .                          

C                          PERU                             X                           

B                          Germany                       Y

A                         Germany                        Y

A                          Netherlands                  Z

C                         Netherlands                   Z

B                         PERU                              W

1) Expected results in Pie diagram

Approved

Not Approved

2) Expected results table

Sample code         Master Product                                    Component

A                           3 (PERU, Germany Netherlands)          3 (X,Y,Z)

B

C

[kentyler]

It looks like different samples can have different components in different countries.

In your results table you want to combine the list of countries and combine the list of result codes  for a sample.

But your example shows no indication of how a sample would be approved, or what the data for an approved sample would be.

If you can explain that perhaps we can help with your DAX