Forum Discussion

Da_clint's avatar
Da_clint
Frequent Visitor
3 years ago
Solved

Count distinc Vendors based on spend values

Hi   Im trying to Count distinct Vendors based on if they have a spend value in a different table. With the DistinctCount I get 9 vendors but as in the right table I only want to show 7 since thos...
Need Help
  • Da_clint's avatar
    Da_clint
    3 years ago
    I Solved it throught:
     
    Invoice Count = CALCULATE(DISTINCTCOUNTNOBLANK('Vendor'[Vendorname]),
    FILTER('Spend actuals',[Spend] >0))
     
     
Da_clint's avatar
Da_clint
Frequent Visitor
3 years ago
I Solved it throught:
 
Invoice Count = CALCULATE(DISTINCTCOUNTNOBLANK('Vendor'[Vendorname]),
FILTER('Spend actuals',[Spend] >0))