Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi Team,
Below are the LOD used in tableau .
Auto Pct
({fixed [Auto or Manual Match] = "Auto",[Vendor] : COUNT([Auto or Manual Match])})
/
({fixed [Vendor]: COUNT([Auto or Manual Match])})
Matches with Adj:
({fixed [Vendor Adjustment Required] = "Yes",[Vendor] : COUNT([Vendor Adjustment Required])})
/
({fixed [Vendor]: COUNT([Vendor Adjustment Required])})
Vendor Adjustment required is Yes
{fixed [Vendor Adjustment Required] = "Yes",[Vendor] : COUNT([Vendor Adjustment Required])}
Vendors with Auto Count:
{fixed [Auto or Manual Match] = "Auto",[Vendor] : COUNT([Auto or Manual Match])}
Need help to recreate in power bi
Regards,
Ravi
@Anonymous , Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.
You can check my video on this topic, How to do fixed LOD in power BI - https://www.youtube.com/watch?v=QdnOHcZqkPU
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.