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
BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
4 years ago

joshua1990 Hi!

CALCULATE(COUNTROWS(Dates[Week]), [Sales] < 500, ALLSELECTED(Dates[Week]))
 
BF
joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
4 years ago

Thanks, but this measure will not work. COUNTROWS allows just tables, not columns

  • BeaBF's avatar
    BeaBF
    Icon for Super User rankSuper User
    4 years ago

    joshua1990 so use COUNT, why do you need to use COUNTROWS? Can't you count the rows of the entire table? 

    It would be easier if you paste some sample data and show the result you would like to get

     

    BF

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

      BeaBF : please find in the initial post the structure of the tables. Works COUNT if you have multiple rows with the same week? 

      • BeaBF's avatar
        BeaBF
        Icon for Super User rankSuper User
        4 years ago

        joshua1990 Can you show me the expected result based on the sample data you have write above?

         

        BF