Skip to main content

Power BI

Needs Votes

Apply cross-filters to data in DAX

Vote (2) Share
Paul Cooper's profile image

Paul Cooper on 05 Nov 2019 19:38:34

Cross-filters only apply to measures. It would be useful to have the ability to apply the current cross-filters to a DAX calculation you can use in columns (and possibly other measures too). The function would probably look something like:

APPLYCROSSFILTERS(

) returns Table.

The table returned would be filtered according to the current cross-filters applied.

Uses would include the ability to have a column in a separate table that depends on the values selected in a cross-filtered table.

I personally would use it to create a single row table with a column that returns a single SVG that is based on the cross-filtered table. This can then be used in HTML Viewer to show the SVG image which would adjust as you use other visualisations to filter the data.

(Please Note you cannot use a measure as the data source in HTML Viewer, only a column)