Forum Discussion
Solved
DirectQuery with RLS- How to get Item level vs Total Level in Matrix
Hello,
Normally, I would use ISINSCOPE or HASONEVALUE to accomplish this, but neither of them are supported for DirectQuery with RLS.
I'm trying to show the correct average value in the tota...
I know you said "without using AVERAGEX", but I am not sure you could achieve without using those functions. Why can't you just use something like:
Avg Price = VAR Items = VALUES ( DimItem[Item] ) RETURN IF ( COUNTROWS(Items) = 1, [Avg Price], AVERAGEX ( Items, [Avg Price] ) )
I know you said "without using AVERAGEX", but I am not sure you could achieve without using those functions. Why can't you just use something like:
Avg Price =
VAR Items = VALUES ( DimItem[Item] )
RETURN
IF (
COUNTROWS(Items) = 1,
[Avg Price],
AVERAGEX ( Items, [Avg Price] )
)