Forum Discussion
Microsoft EmployeeStrange behavior in week over week table
Hi tessaw ,
The cause is that your date filter will also filter the Response Code. Another separate Response Code table is needed to be created, which won't be filtered by your date filter. Steps are as follows:
1. Create a Response Code table.
Response Code = VALUES(AzureDataExplorer[ResponseCode])2. Change your [TotalCount] measure like so:
TotalCount = CALCULATE ( SUM ( AzureDataExplorer[Count] ), FILTER ( AzureDataExplorer, AzureDataExplorer[ResponseCode] IN VALUES ( 'Response Code'[ResponseCode] ) ) )3. Replace AzureDataExplorer[ResponseCode] with 'Response Code'[ResponseCode] in your table visuals.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft EmployeeAhhh!! Thank you! That worked!
I understand that the date filter was also filtering response code but could you explain why were only a few of the counts of response codes affected? Why wouldn't all the values be affected?
