Forum Discussion

apple43's avatar
apple43
Frequent Visitor
1 year ago

Count within a baseline

Hi Community,    I have following situation:    I need to have a measure that gives me number of sales that are within specific baseline.  See below an example:  Seller Qty Product Countr...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi apple43 

 

Thanks for the reply from uzuntasgokberk and GiuseppeMR .

 

Is this the desired outcome you want? Please refer to the test below. 

 

Sample data:

I used some of the sample data you showed. I want to confirm with you whether these data are original data. If there are calculated columns or measures, we need you to show the corresponding formulas to better reproduce your scenario.

 

Create a measure as follows

 

Measure = CALCULATE(SUM('Table'[Qty]), FILTER('Table', 'Table'[Price per unit] <= 'Table'[Baseline (price per unit)]))

 

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

apple43's avatar
apple43
Frequent Visitor
1 year ago

Hi Anonymous , 

 

Your suggestion is not working! 

Regarding information about data: 

- Qty (measure) - table1[qty]  =  CALCULATE([Qty], Product[Product]= "A"|| Product[Product]= "B")

- price per unit (measure) - table2[Price per unit] (DirectQuery)

- baseline (measure) - table3[baseline] (DirectQuery)

 

Neither are calculated columns. 

 

Thanks in advance!