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
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.