Forum Discussion

vivek_babu's avatar
vivek_babu
Icon for Helper II rankHelper 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
shafiz_p's avatar
shafiz_p
Icon for Super User rankSuper User
1 year ago

Hi vivek_babu  Try this:

Measure = 
var r_year = SELECTEDVALUE(PA_TOOL_COMPLIANCE_WINDOWS[Reporting Year_windows])
var r_month = SELECTEDVALUE(PA_TOOL_COMPLIANCE_WINDOWS[Reporting Month_windows])
var prev_date = EOMONTH(DATE(r_year, MONTH(DATEVALUE("1 " & r_month & " " & r_year)), 1), -1)
var prev_year = YEAR(prev_date)
var prev_month = FORMAT(prev_date, "MMM")
return
CALCULATE(
    COUNTROWS(BLADE_LOGIC_FIM),
    FILTER(
        BLADE_LOGIC_FIM,
        BLADE_LOGIC_FIM[Reporting Year_fim] = prev_year &&
        BLADE_LOGIC_FIM[Reporting Month_fim] = prev_month
    )
)

 

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

 

Best Regards,
Shahariar Hafiz