Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
4 years ago

COUNTROWS with ALL and data selection

Hi experts! I use a simple COUNTROWS Measur to count the number of weeks with a value below a target:     COUNTROWS(FILTER(ALL(Dates[Week]), [Sales] < 500))       I use a slicer in the same...
Need Help
v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, joshua1990 

Try this:
1)

measure =
COUNTROWS ( FILTER ( ALLSELECTED ( Dates[Week] ), [Sales] < 500 ) )

2)

measure =
COUNTROWS (
    SUMMARIZE (
        CALCULATETABLE ( 'Calendar Table', 'Transactional Table'[Sales] < 500 ),
        [Week]
    )
)

Or, please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.

 

Best Regards,
Community Support Team _ Zeon Zheng

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