Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a measure which have to show blank values when Year field is filtered (or has one value), and show values in other case:
SUM if Year Not Filtered = IF(ISFILTERED(Years[Year]);BLANK();[Summ])
When I put this measure in matrix visual and [Year] in Columns, and some other field in Rows, Matrix shows all rows and no years (expected), but also shows total column for each row:
But when I swap fields ([Years] to rows and other field to columns), totals row is empty:
After some (long) investigation I found that this behavior is because "Stepped layout" is ON by default. Setting this option to OFF cause totals to appear.
I can see no reason for this behavior - it have to show totals in any case, as it supposed by DAX semantics.
It is very confusing behavior, because totally unclear and differs from other tools like Power Pivot.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.