Urgent Help wanted for having the right dax queries!!

koningii — Thu, 12 Mar 2020 09:39:05 GMT

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)

Re: Urgent Help wanted for having the right dax queries!!

kentyler — Sat, 14 Mar 2020 15:19:53 GMT

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