count rows per day with measure as a condition

[Anonymous]

Hi, I am currently developing a report in Power BI desktop, one is a pivot table with the following columns:

Row: StoreCode

Column: Date

Value: Variance (calculated as measure)

Apart from that, I want to create a new summary table that will return count of StoreCodes per Date with Variance > x. Is it possible to set measure as a criteria to calculate the count? The report is in direct query mode. 

[v-xicai]

Hi  @Anonymous ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

  Hi @Anonymous ,

Yes, it is possible to set measure as a criteria to calculate the count. Try to create measure using DAX below.

measure1 = CALCULATE(COUNT(Table1[StoreCode]),FILTER(ALLSELECTED(Table1),Table1[Date ]=MAX(Table1[Date ])&&Table1[Variance ]>x))

Best Regards,

Amy

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