topic To find Minimum number for particular order number in DAX Commands and Tips

To find Minimum number for particular order number

jimpatel — Fri, 09 Jun 2023 10:18:47 GMT

Hi,

Thanks for looking at the post.

I got below measure

Measure 4 = SWITCH(TRUE(),'Table1'[Measure 3] = "Ok",1,'Table1'[Measure 3] = "Not Ok",1000)

What i am looking for is, I got order numbers and i wanted to see if one of them is not ok for that order number then rest of them should automatically turn to not ok as well please.

I am using something like below but i am getting circular error.

Calculation=

AVERAGEX(

KEEPFILTERS(VALUES('Table1'[ORDERNUMBER])),

CALCULATE(MIN('Table1'[Measure 4 ]))

)

Any idea please

thanks

Re: To find Minimum number for particular order number

lbendlin — Sun, 11 Jun 2023 17:42:37 GMT

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523