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
Mhnsan1113
Frequent Visitor

logic building

Hi  

Have created this the below calculated column logic and used in table below

s_descs = if(tbvw_overdue_order_leadtime_vw[vendors]="WESCO INTEGRATED SUPPLY INC" && [plant]="6500"  ,"Wesco Integrated Supply"if(tbvw_overdue_order_leadtime_vw[Ariba/Non-Ariba]="Ariba" && ([plant]="6500"||[plant]="6540"),"Ariba Vendors").the output is below.
But the challege is the Ariba vendors includes wesco integrated supply count. I want Ariba vendors count should show  2888+500= 3388 and Westco integrated supply as 500 . 
Mhnsan1113_1-1661494199762.png

Request if someone can help and guide

REgards

 

Mohan
4 REPLIES 4
lbendlin
Super User
Super User

Don't do that. You would introduce data duplication and confuse your users. 

 

Instead, let the matrix visual do the work. Create a Group "Ariba vendors" based on your logic and then show Wesco in the hierarchy below,  as one of the Ariba partners.

Thanks for reply,  Above table "Ariba vendors" has sub-vendor and wesco is one of the sub-vendor for Ariba, and Wesco is also a parent vendor and sub vendor too. When logic build for Ariba tbvw_overdue_order_leadtime_vw[Ariba/Non-Ariba]="Ariba" && ([plant]="6500"||[plant]="6540").Wesco is getting Captured in Ariba, But cliet wanted that count should get added in both. Is there any workaround or logic to build. Please suggest 

 

Take my advice or leave it - I would handle that in the source data.

Thanks for revert, so there is no workaround to the resolution? only option is the one you suggested?

 

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.