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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
KevBI
Helper I
Helper I

Measure that checks multiple Rows based on one value

Hey Guys,

I can't come up with this Measure, I hope you can help me out!

I have following Table: 

PO-NumberPO CategoryPrice
12300E90
12300Q90
22200E45
22200Q45
33500E20
44000E57


So the Measure that I am trying to come up with should check if a PO Number has the Category "E", but not the Category "Q". 
If that Case is true, and no row has the category "Q", the Price would be added to the Measure.

Thanks a lot!!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Ok,


sO HERE IT IS

JamesFr06_0-1653467026018.png

 

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Ok,


sO HERE IT IS

JamesFr06_0-1653467026018.png

 

wow great, thank you so much!!!

I would have another question that i forgot. 
The Price is in another Table with the same PO-Numbers.

Do you know how i could put the price from another table in the variable "selectprice" ?

Anonymous
Not applicable

Yes you can if you put this field in the final report.

Just change teh reference in selectprice

Anonymous
Not applicable

Hi

 

Just to be sure. Is it what youare looking for ?

JamesFr06_0-1653465725400.png

 

2022-05-25 10_18_46-Re_ Measure that checks multiple Rows based on one... - Microsoft Power BI Commu.png

The red ones should also be blank, as these PO Numbers have a row with "E" and a row with "Q".
The last two ones are correct as they only have a row with "E".

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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