Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
thurlowj
New Member

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 display under the 'Total' row and I can't get it right. Could someone help?

 

 

thurlowj_0-1712322896432.png

 

1 ACCEPTED SOLUTION

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 ] )

View solution in original post

12 REPLIES 12
AnalyticPulse
Impactful Individual
Impactful Individual

you are using selectedvalue in your measure maybe your measure is returning the values as text and if there is blank value in your data then that blank values is being shown on the total as the total ot text field is always text . 

no.

AnalyticPulse
Impactful Individual
Impactful Individual

have you enables total option in format pane in your visual settings?

 

I wish this was the solution!

obviously, since there's the text "Total".

lukiz84
Memorable Member
Memorable Member

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

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. 

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?

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

 

thurlowj_0-1712325708298.png

 

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 ] )

Wow. I was over complicating things for myself, huh? Thank you so much, I went with the second solution. I really appreciate your help with this!

you're very welcome. i've been there myself, overcomplicating stuff 🙂

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.