Forum Discussion
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....
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
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