Evaluating the Logic as per Data Slicer Applied

[Gaurav_Lakhotia]

Hi All,

I need your help in creating a measure,

Here is the scenario,
1. A company provide various services (A,B,C....) to different clients.
2. These services are provided on different contact dates e.g. A can be provided on 1st Oct while B can be provided on 5th Oct to the same client.
3. The dataset has a row for each contact and columns for different services.
4. If a client has received certain set of services during selected period then this client is called "Reached"
5. The condition for declaring a client "Reached" are as

Client =
IF (A OR B OR C = True
AND
D is not blank OR E is true
AND
F OR G = true
AND
H > 0 OR J > 0 OR K = True), "Reached" )

Note: If we select a date range, the above condtion should work as per the given date range. We have to take care of client name also.

Here is the file with Sample Data .

Thanks

[v-shex-msft]

Hi  @Gaurav_Lakhotia,

I'd like to suggest you do 'unpivot column' on your condition fields to convert them to attribute and value, then you can use two fields to accurately control the if statement and conditions.

Unpivot columns (Power Query) 

Regards,

Xiaoxin Sheng

[Payeras_BI]

Hi @Gaurav_Lakhotia ,

Here goes my try:

Reached measure =

SWITCH(

TRUE(),

("T" IN VALUES ('Table'[A]) ||"T" IN VALUES ('Table'[B]) || "T" IN VALUES ('Table'[C]))

&& ("Yes" IN VALUES ('Table'[D]) || "T" IN VALUES ('Table'[E]))

&& ("T" IN VALUES ('Table'[F]) || "T" IN VALUES ('Table'[G]))

&& ( SUM ('Table'[H]) > 0 || SUM ('Table'[J]) > 0|| "T" IN VALUES ('Table'[K])),

"REACHED","NOT REACHED"

)

Regards,

[Payeras_BI]

Hi @Gaurav_Lakhotia ,

Could you try the proposed measure in your sample data? Did it work as expected?

Reached measure =
SWITCH(
TRUE(),
("T" IN VALUES ('Table'[A]) ||"T" IN VALUES ('Table'[B]) || "T" IN VALUES ('Table'[C]))
&& ("Yes" IN VALUES ('Table'[D]) || "T" IN VALUES ('Table'[E]))
&& ("T" IN VALUES ('Table'[F]) || "T" IN VALUES ('Table'[G]))
&& ( SUM ('Table'[H]) > 0 || SUM ('Table'[J]) > 0|| "T" IN VALUES ('Table'[K])),
"REACHED","NOT REACHED"
)

[Payeras_BI]

Hi again @Gaurav_Lakhotia,

I could not post before the screenshots of the measure working.

See below:

Regards,