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
Hi
Have created this the below calculated column logic and used in table below
Request if someone can help and guide
REgards
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
102 | |
98 | |
89 | |
70 |
User | Count |
---|---|
166 | |
131 | |
129 | |
102 | |
98 |