Forum Discussion

vivek_babu's avatar
vivek_babu
Helper II
1 year ago
Solved

Countrows not working properly

Hi,   I am trying to count the rows based on the year and month column selected in the slicer. When a user selects Year = 2022 and Month = Jan then i need to count the rows for the previous month. ...
Need Help
  • vivek_babu's avatar
    vivek_babu
    1 year ago

    Hi All,

     

    The issue was with the filter function inside the calculate function. I removed the filter and directly applied the condition and it worked. Thanks for your help!

    Prev_Sales =
    Var r_year = SELECTEDVALUE('Table'[Year])
    var r_month = SELECTEDVALUE('Table'[Reporting Month Number])
    VAR prev_month = IF(r_month = 1, 12, r_month - 1)
    VAR prev_year = IF(r_month = 1, r_year - 1, r_year)
    RETURN
    CALCULATE(SUM('Table'[Sales]),
    'Table'[Year] = prev_year && 'Table'[Reporting Month Number] = prev_month)
     
    Regards
    Vivek N
vivek_babu's avatar
vivek_babu
Helper II
1 year ago

Hi All,

 

The issue was with the filter function inside the calculate function. I removed the filter and directly applied the condition and it worked. Thanks for your help!

Prev_Sales =
Var r_year = SELECTEDVALUE('Table'[Year])
var r_month = SELECTEDVALUE('Table'[Reporting Month Number])
VAR prev_month = IF(r_month = 1, 12, r_month - 1)
VAR prev_year = IF(r_month = 1, r_year - 1, r_year)
RETURN
CALCULATE(SUM('Table'[Sales]),
'Table'[Year] = prev_year && 'Table'[Reporting Month Number] = prev_month)
 
Regards
Vivek N