I did one calculation to show what I need, Results in 4 previous quarters but now when I bring a category it disappears although the relationship is fine and works properly.
If I put the same category in the Filter pane, it works well.
Can someone know where the problem should be?
These are the calculations that I did:
This is for the count:
*Total Number = if(NOT isinscope(Results[Result (+/-)]) && HASONEVALUE(Results[Result (+/-)]), BLANK(), COUNTROWS(TimestampExportReport) )
I did a table for only Years and Quarters.
After that, I did this calculation where I put as a filter on the filter pane and everything is good till now:
VAR _yearQuarter =
MAX ( ‘Calendar’[Years] ) * 100
+ MAX (‘Calendar’[Qtr])
return IF(_yearQuarter<=_max &&_yearQuarter>=_min,1,0)
As I said when I put the Category, it disappears the result.
I did this video where you can see it.