New Measure Required if for One Row in Matrix is NO, it should present No for all Order Rows.

[pbix_users]

Hello, Need a measure to present Yes/NO based on condition. If only one is NO in SKU 85 Measure the new measure should present 'NO" for each row. in this case for sales id 0002, i need to present Yes, for each row and in second case for Sales ID 269 need to present "NO" for all rows as we have no against size 30 30. Actually need to use "AND GATE"Rules, for Open all values should be "Yes" if one of the value is NO it should be NO against all rows. (SKU 85 is also a measure 

SKU 85 = IF([Measure] >0.85 ,"Yes","No")). Need new measure based on (SKU 85).

[v-yajiewan-msft]

Hi @pbix_users ， hello Kedar_Pande, thank you for your prompt reply!

Please create the measure as shown below:

New Measure = 
IF(
    CONTAINSSTRING(
        CONCATENATEX(
            FILTER(ALL('Table'), 'Table'[Sales ID] = MAX('Table'[Sales ID])),
            [SKU 85],
            ""
        ), 
        "No"
    ),
    "No",
    "Yes"
)

Result:

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pbix_users]

Wrong, it should be Yes for sales id 1. and no for 269.

[v-yajiewan-msft]

Hi @pbix_users ,

Thank you for your feedback.

If possible, could you please upload your PBIX file for further troubleshooting?

Please ensure it contains sample data that doesn’t include any sensitive information.

Thank you for your understanding!

[pbix_users]

? Need to implement "AND" condition if all rows equal to yes, then "Yes". If one of the row equal to "No" for all rows against particular sales order it should present "NO".

[Kedar_Pande]

Final Result measure:

Final Result = 
IF (
COUNTROWS (
FILTER (
VALUES('YourTableName'[Sales ID]),
CALCULATE( 
MIN('YourTableName'[SKU 85]) 
) = "No"
)
) > 0,
"No",
"Yes"
)

If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande

[pbix_users]

@Kedar_Pande 

MIN('YourTableName'[SKU 85]) 

SKU85 is also a measure. when i put min against measure, i got an error.

he MIN function only accepts a column reference as the argument number 1.

This measure doesn't works in my case.

[Kedar_Pande]

@pbix_users 

Updated Measure:

Final Result = 
VAR _val=[ SKU 85 ]
IF (
COUNTROWS (
FILTER (
VALUES('YourTableName'[Sales ID]),
CALCULATE( 
_val  = "No"
)
) > 0,
"No",
"Yes"
)

[pbix_users]

@Kedar_Pande  Same Results, it should be YES, for all rows.