Forum Discussion
Let visual be ignored by specific filter(s)
Hi Anonymous ,
Could you please try to add the field "week" of table "UNIT" into Filters pane instead of the field "WeekNr" of table "CALENDAR"?
Best Regards
Rena
Hi Anonymous ,
Whether the filter field applied on page-lvel filter is from the field "Week" in table "Unit"? And the formula of measure "Amount_Unfiltered" as below:
Amount_Unfiltered = CALCULATE(SUM(UNIT[Amount]),ALL('UNIT')) |
Best Regards
Rena
Hi Anonymous ,
I am not sure what you mean by that, but the "Week" field on the x axis is from the CALENDER table.
The values on the y axis are from the UNIT table.
The UNIT table does have a "Week" field, but it's not used in the visual, and has a relationship to a "Week" field in the CALENDAR table which is used in the visual.
Hi Anonymous ,
Could you please try to add the field "week" of table "UNIT" into Filters pane instead of the field "WeekNr" of table "CALENDAR"?
Best Regards
Rena
Hi Anonymous ,
That works, obviously, because the data points are from the same table. I always assumed this worked cross-table as well.
Hi Anonymous ,
Is there anything else about this thread that I can assist you? If no, could you please mark the helpful post as Answered? It will be helpful to anyone who might experience the same problem. Thank you.
Best Regards
Rena