Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
Solved! Go to 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 ] )
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.
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".
If you could show the measure it would help a lot 😉
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
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 🙂
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
10 | |
10 | |
9 | |
9 |
User | Count |
---|---|
20 | |
13 | |
12 | |
11 | |
8 |