Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jimpatel
Post Patron
Post Patron

To find Minimum number for particular order number

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

 

1 REPLY 1
lbendlin
Super User
Super User

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-...
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/1447...

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.