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.
Hi I have a dax formula thats supposed to calculate the percentage of the number of sales transactions based on a selected status. However when I enter in this dax formula:
@SeanB004 , when the values are from the same table you do not need to handle
You need to create a measure
divide(COUNTROWS(CompanyOpportunities), calculate(COUNTROWS(CompanyOpportunities), removefilters(CompanyOpportunities[status]) ) )
https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak