Count rows where sum is greater than [defined value]

[KUNGFUPANDA559]

I have screenshots of the excel equivalent.  I'd like to find sales_id that have sales greater than 3000.  All help is appreciated!

[Phil_Seamark]

HI @KUNGFUPANDA559

If you add the following calculated measure to your model, you can then set the filter to only show when it equals 1

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

[KUNGFUPANDA559]

@Phil_Seamark

The next question would be filtering based on the results, and counting rows.  My assumptions are it'd be written similar to :

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

Filter Count= CALCULATE(COUNTROWS(FILTER MEASURE),FILTER MEASURE = 1)

My filter count field does not work in this situation.  

[Anonymous]

Try this

Filter Count = CALCULATE(COUNTROWS('table1'),FILTER(financials,CONTAINSROW({1},([Filter Measure]))))

[KUNGFUPANDA559]

There must be something missing.  When i select matrix visualization.  I see 1,0 broken out by sales_id.  However when i use the card visualization it says "blank" as measure value (more blanks? first value blank?  does not show count of records)

[v-xjiin-msft]

@KUNGFUPANDA559 

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.

[KUNGFUPANDA559]

@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!