Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |