Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Count rows where sum is greater than [defined value]

I have screenshots of the excel equivalent.  I'd like to find sales_id that have sales greater than 3000.  All help is appreciated!    
Need Help
v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Anonymous 

 

I have made some test. However I did not encounter your issue. Please refer:

 

Expressions for measure Filter Measure and Filter Count:

 

Filter Measure =
IF ( SUM ( 'Table1'[SALES_TOTAL] ) > 3000, 1, 0 )
Filter Count =
CALCULATE (
    COUNTROWS ( Table1 ),
    FILTER ( Table1, Table1[Filter Measure] = 1 )
)

 

As you can see I got Matrix and Card. Everything works fine. So in your scenario, could you please share us your using measure expressions? And how did you define the Matrix and Card? Could you please share us some screenshots about them? 

 

Also, it will be more helpful if you can share us some sample data which can help us reproduce your issue.

 

Thanks,
Xi Jin.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

v-xjiin-msft

 

The issue may have been the date filter context of another column.  In the end the correct measure was:

 

CALCULATE(DISTINCTCOUNT(Sales[Sales_ID]),FILTER(VALUES(Sales[Sales_ID]),[YTDSales]>3000))

 

thanks for your direction!