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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Dexter1088
Frequent Visitor

Multiple IF Measure with one to many relation

Looking for a measure that will tell me if there are any issues open on that item and also if any like issue has occured in the last 20 days.

Tried this, but it's not catching everything. any suggestions? ty

 

 

IF(MAX(TICKET TABLE[Unique_Tie])<>MAX(ISSUE TABLE[Unique_Tie]) && MIN(ISSUE TABLE[Age of issue])<0, "NO",
IF(MAX(TICKET TABLE[Unique_Tie])=MAX(ISSUE TABLE[Unique_Tie]) && MAX(ISSUE TABLE[Age of issue])<20, "NO"
,"YES")))

 

 

 

 

 

  ISSUE TABLE
ItemIssueUnique_TieAge of issueDate of issue
1A1_A218/23/2024
2A2_A258/19/2024
3B3_B129/1/2024
1B1_B  
2A2_A557/20/2024

 

 

  TICKET TABLE
ItemIssueUnique_TieDesired Outcome
1A1_AYES
2A2_ANO
3B3_BYES
3 REPLIES 3
v-bofeng-msft
Community Support
Community Support

Hi @Dexter1088 ,

 

Could you please tell me:

 

Are you looking to retrieve the 'TICKET TABLE' based on the 'ISSUE TABLE'? If so, are you grouping by Item to check whether the group contains any records where the 'Age of issue' is less than 20 or is blank?

 

Additionally, for the 'Ticket Table,' on what conditions do you retain 'Issue' and 'Unique_Tie'? Since an Item may have both Issue "A' and "B", as well as Unique_Tile values like "1_A" and "1_B", do you only need to retain the first record's Issue and UniqueTile for that group?

 

Best Regards,
Bof

ryan_mayu
Super User
Super User

not clear about the logic? what about 1_B?

why 2_A is NO? I think it's 25 days which is more than 20





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Item 1 Issue B is still active because it's blank
Item 2 Issue A is a NO because the issue cleared over 20 days ago

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 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.

October NL Carousel

Fabric Community Update - October 2024

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