Forum Discussion
Using countx with three conditions
Hi everyone, I have a table of risks and the calendar table. I need to calculate the number of risks that were open in a certain period, where their status is high and the date closed should be withi...
Everything seems to be correct. But I cannot understand this why use CROSSFILTER?
Also, since MAX(Calendar[date]) is used, did you check if the max date points to some future date where there might not be vulnerabilities?
If you can share a sample data pbix file, it would be helpful to look at.