Solved: DAX - Count of days with target achieved

kostask · ‎02-07-2022

Hi, guys.

For the following 1st table, I'm struggling to calculate the measure (DaysWithSales>1000) that gives the number of distinct days that each products' sales, are in total (Sum of lines' Sales) over 1000 (2nd table).

Thanx in Advance!!

Kostas

amitchandak · ‎02-07-2022

@kostask , display this measure with product in a visual

Countx(filter(Summarize(Table, Table[product], table[Date], "_sales", sum(Table[Sales])), [_sales]>1000),[product])

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

kostask · ‎02-08-2022

This works perfectly @amitchandak .

Another great solution of you!

Thanx !

amitchandak · ‎02-07-2022

@kostask , display this measure with product in a visual

Countx(filter(Summarize(Table, Table[product], table[Date], "_sales", sum(Table[Sales])), [_sales]>1000),[product])

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

DAX - Count of days with target achieved

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024