Measure syntax to show overall aggregate total when not filtered

[AndyDDC]

Hi,

I'm trying to create a measure that shows the overall total in a Fact table when placed in a visual, however if the measure is placed in a visual with a Dimension table with RLS like a table, I would like the table total in that visual to reflect only the total the user can see.

For example, if the "Total Sales" measure is used on its own with no dimensions then it should show the total for everything.

If the Customer dimension is used (which has RLS) then I would like the measure to calculate the total based only on the Customer Group the user is able to see.

I've tried using ISFILTERED but then I get the whole total in the bottomm table grid, presumably because the total is not filtered and therefore shows everything.

Any pointers would be appreciated.

Thanks

[amitchandak · Accepted solution]

@AndyDDC , Try isinscope and hasonevalue and check

https://xxlbi.com/blog/new-dax-function-isinscope/

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/