PowerPivot Countif

New Contributor

I am working on a countif formula within powerpivot and the below formula works but it's not returning the correct percentage: 

=calculate(DISTINCTCOUNT(Table1[Unit Price Sold - Daily LP Rate Converted to Hourly LP Rate]),FILTER(Table1,Table1[Unit Price Sold - Daily LP Rate Converted to Hourly LP Rate]>[Low End Median Range]&&Table1[Unit Price Sold - Daily LP Rate Converted to Hourly LP Rate]<[High End Range]))/[Count of Unit Price Sold]

 

Note the formula is pulling from another powerpivot measure itself but I wouldn't think that would be the issue? Low End Median Range and High End Median Range are both measures. I've also tried every type of countif possible in DAX. Anyways, any help would be great. 

0 Replies