The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I want to get the % for this visual, so that it says 100% (because it hit the target)
however, when I written a DAX function for it, I couldn't get the correct %
"Target Percentage = COUNT(Company[CompanyName]) * 30 / 1000"
It comes up as 90% for some reason I'm not sure why.
Solved! Go to Solution.
@Anonymous , if 30 is traget then
COUNT(Company[CompanyName])/ 30
And mark it as % column