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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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