Forum Discussion
joshua1990
Post Prodigy
Post ProdigyCOUNT Weeks with Value between Levels
Hi experts! I have a simple DIVIDE Measure (Measure x) that shows me the Ration between two different measures: DIVIDE ([Measure 1], [Measure 2]). Now I would like to get the number of weeks wh...
Please try
Number of Weeks < 0.075 = COUNTROWS ( FILTER ( VALUES ( 'Calendar'[Week] ), [Measure X] >= 0 && [Measure X] < 0.075 ) )
tamerj1
Community Champion
Community ChampionPlease try
Number of Weeks < 0.075 =
COUNTROWS (
FILTER ( VALUES ( 'Calendar'[Week] ), [Measure X] >= 0 && [Measure X] < 0.075 )
)