Forum Discussion

rpinxt's avatar
rpinxt
Solution Sage
2 years ago
Solved

Placeholder error

Is there a way to tackle this? I want to count the IDs where the closure month is equal to the period. It will not let me and I am not sure where the problem exactly is....
Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, rpinxt 

    use your filter part of calculate in FILTER function.

    try below code 


    closed =
    calculate(distinctcount('case'[id]),
                     filter('dimdate',dimdate=[closure month])

                   )

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. and don't forget to give kudos

rpinxt's avatar
rpinxt
Solution Sage
2 years ago

Maybe I need to elaborate more.

 

I have a table called 'Case' and one field in this table is called [CloseDate].

And I have an autocalendar which gives me period (linked to a date field in the 'Case' table), 'dimDate'[Period].

 

Now I want to count the field 'Case'[Id] where the 'Case'[CloseDate] = 'dimDate'[Period].

 

But I cannot reference the field 'Case'[CloseDate] in my measure without using for example MAX.

However then I get only 1 period and I need it to look in every period and then give me the amount for that month.