Forum Discussion
Total discrepancy when using a countrows filter measure in a card visual
Hello I've checked some posts and watched some videos but cannot find a solution yet. I am trying to count the number of rows in a table which have certain criteria but the total showing in t...
It could be some underlying relation of filters that is effecting the measure. If your data is not sensitive, can you share the pbix file. I won't be able to scope out where the problem lies without seeing the data and the report.
DatawithDinesh
Resolver II
Resolver IIHello Andy,
First issues I see there is how your query is filtering out the data. Can you update your query with the below one.
Here is the revised query.
Ttl 1w =
CALCULATE(
COUNTROWS('All Tasks'),
FILTER(
'All Tasks',
'All Tasks'[daysOldInInterval] >= 2 && 'All Tasks'[daysOldInInterval] <= 5
)
)
Thanks, I just updated the measure but the card total is still the same...is something else wrong ?
- DatawithDinesh
It could be some underlying relation of filters that is effecting the measure. If your data is not sensitive, can you share the pbix file. I won't be able to scope out where the problem lies without seeing the data and the report.