Forum Discussion

thurlowj's avatar
thurlowj
New Member
2 years ago
Solved

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's avatar
    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 ] )
lukiz84's avatar
lukiz84
Icon for Memorable Member rankMemorable Member
2 years ago

If you could show the measure it would help a lot 😉

thurlowj's avatar
thurlowj
New Member
2 years ago
DCOH Mean = calculate(Geomean('Table'[ DCOH ]), FILTER('Table', 'Table'[Locid]= selectedvalue('Table B'[Locid])))
 
Here's the measure for my DCOH Mean calculation.
 
I tried several measures to get the sum to generate for my selected entries but it adds a column. 
 
Obviously new to this, but this is my first attempt of using slicers so I can compare different selected data.  Not sure if that has anything to do with the total number not displaying though. 
  • lukiz84's avatar
    lukiz84
    Icon for Memorable Member rankMemorable Member
    2 years ago

    The problem could be SELECTEDVALUE.

     

    In the Total Row, SELECTEDVALUE returns BLANK() because there are more then "one" values selected. 

     

    What's "Table B"? Can you show the relationships?

    • thurlowj's avatar
      thurlowj
      New Member
      2 years ago

      Thanks for your help so far, that makes sense. 'Table B' contains my Locid selections

       

       

      • lukiz84's avatar
        lukiz84
        Icon for Memorable Member rankMemorable Member
        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 ] )