How to get out of current row context in a visual table in a measure

[Anonymous]

Hi,

I have a raw data table, which has data for sales of products to customers and some other related fields like region, main group, whether contracted, sales channel, etc.

I want to display a table which uses slicer filters and displays data accordingly. Additionally, in the row cVolume customer 1, it should display the total volume that the customer in context is buying in the currently displayed rows. Just to show as an example, cVolume customer(Total volume that customer is buying regardless of any product; eg SOLENIS 182.9 is the total volume for all products it buys) contains the right values cVolume customer 1 should be showing. 

I am using the measure for cVolume Customer 1, but its not getting out of the current row context for PRD. 

I also tried using COBUS[PRD] instead of cutomer hierarcy in the measure formula and still the exact same values.

Please help!!

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

If you want to get out of context, you can try to use the ALL or ALLEXCEPT function.

ALL returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. This function is useful for clearing filters and creating calculations on all the rows in a table.

ALLEXCEPT removes all context filters in the table except filters that have been applied to the specified columns.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

@Anonymous 

Please share some sample data or PBIX file and a clear depiction of the expected outcome.