Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

finding values not zero

Greetings,   This simple DAX formula is eluding me.   I have a report filtered by Supplier, and I wish to count the number of customers who have purchased some of their product in 2017 (Gross > 0...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

I am now completely confused.  You are now bringing another table.  All this while you were talking about only 1 table.  Now there are two.  Please explain the question very clearly.  Do not be concerned with any formulas.  First explain the business problem clearly.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I apologize for causing confusion. Per my BI sample, I am working with the “gross_sales”. I am looking to determine the number of Suppliers (manufacturer_id) with purchase made in 2017 by Dealers(user_id), this would determine the number of “Active Dealers”.

 

I created the measure “Sales 2017” to isolate sales in 2017, and then filter by Supplier, by Dealer, and then counting the number of rows greater than zero.

 

Best

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Greetings,

     

    Looking for solution to my DAX formula issue?

     

    Re: finding values not zero
     
     

    Saturday

    I apologize for causing confusion. Per my BI sample, I am working with the “gross_sales”. I am looking to determine the number of Suppliers (manufacturer_id) with purchase made in 2017 by Dealers(user_id), this would determine the number of “Active Dealers”.

     

    I created the measure “Sales 2017” to isolate sales in 2017, and then filter by Supplier, by Dealer, and then counting the number of rows greater than zero.