Forum Discussion
Getting the Average from a Y/N column
Anonymous OK, so you are looking for percentage by Site Name. Try these measures:
Total Orders Verified = CALCULATE( COUNT( Table[OrderId]) , Table[Status] = "Verified", Table[ Meets Criteria] = "Y" )
Total Orders = COUNT( Table[OrderID])
Percent Verified = DIVIDE( [Total Orders Verified] , [Total Orders] )
Use a slicer for Site Name or put Percent Verified in a visual with Site Name. If you want this to work when drilling down to order ID level, you'll need to add another filter context shift, for example using:
Percent Verified This Site = CALCULATE( DIVIDE( [Total Orders Verified] , [Total Orders] ), ALLEXCEPT(Table[Site Name])
AllisonKennedy I do have the Order ID as one of the columns in the same table.
I need to know which sites had 85% verified orders per month.
Community ChampionAnonymous OK, so you are looking for percentage by Site Name. Try these measures:
Total Orders Verified = CALCULATE( COUNT( Table[OrderId]) , Table[Status] = "Verified", Table[ Meets Criteria] = "Y" )
Total Orders = COUNT( Table[OrderID])
Percent Verified = DIVIDE( [Total Orders Verified] , [Total Orders] )
Use a slicer for Site Name or put Percent Verified in a visual with Site Name. If you want this to work when drilling down to order ID level, you'll need to add another filter context shift, for example using:
Percent Verified This Site = CALCULATE( DIVIDE( [Total Orders Verified] , [Total Orders] ), ALLEXCEPT(Table[Site Name])