Total not displaying in Row

Hi! I think I'm missing something obvious but I have tried so many different measures and none of them have worked and honestly getting no where each time I look at it. I want to see the Total displa...

lukiz84

2 years ago

Workaround could be:

DCOH Mean =
VAR IsTotal = NOT (HASONEVALUE('Table B'[Locid]))
VAR SingleVal =
CALCULATE (
    GEOMEAN ( 'Table'[ DCOH ] ),
    FILTER ( 'Table', 'Table'[Locid] = SELECTEDVALUE ( 'Table B'[Locid] ) )
)

VAR TotalVal =
GEOMEAN('Table'[DCOH])

RETURN IF(IsTotal, TotalVal, SingleVal)

BUT I don't understand why you do it this way in the first place. Just make a relationship between Table 2[Locid] (1) to Table[Locid] (m) (1:m) and alter your measure to:

DCOH Mean =
    GEOMEAN ( 'Table'[ DCOH ] )

Forum Discussion

Total not displaying in Row

Related content

Forecast total display

Display Grand total

display total in matrix visual

Runing total display

Power BI total not displaying properly