Apply filters to new table

[ronlovesdata]

Hello,

I'm trying to create benchmarks that dynamically adjust to certain criteria within a drill down chart. I'm only concerned with brand, ad size, and platform, so I tried creating a custom table that's grouped by those three criteria. I am running into an issue where filters I've applied to the report aren't affecting this new custom table, so the results from that table are over reporting certain metrics. Is there a good way to apply the same report filters to this new custom table I'm creating for benchmarks? Here's the DAX for the table:

Brand Benchmarks =

GROUPBY( vw_media_summary, vw_media_summary[brand], 'Date DIM'[Date], vw_media_summary[platform], vw_media_summary[Ad Size (edit)],

"Impressions", SUMX(CURRENTGROUP(),vw_media_summary[Impressions]),

"Clicks", SUMX(CURRENTGROUP(),vw_media_summary[Clicks]),

"Video Completions", SUMX(CURRENTGROUP(),vw_media_summary[video_views_to_100p]),

"Video Views", SUMX(CURRENTGROUP(),vw_media_summary[Video Views])

)

I imagine this is fairly straightforward in PowerQuery, however when I go to the transform tab, this table isn't showing up under queries so I'm trying to find a way to filter it within the DAX formula. Any help is appreciated, thanks!

[parry2k]

@ronlovesdata calculate table will not work with the slicer. I'm not sure why you are creating a calculated table, you can simply add measures and then use those in the visual and will work with slicers. Not sure if you really need a calculated table, maybe I'm missing something here.