Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi ,
What's the expectation? Do you want to see the average?
HI
You can use this DAX pattern to solve issues like these to get the expected "total" (totals are not totals, but just the result of your expression evaluates without the context provided by each of the "rows" in the table.
NewMeasure = SUMX(Values(Table[ColumnInYourVisual]), [_DaysWeightedAverageTemp])
Use the above type measure in your table. The rows and the total should give the expected results.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
use the IF(HASONEVALUE()) construct to differentiate between the caclulation for the visual rows and for the totals.
@sivashankr is this a measure? If yes what is the expression? if it dependent on other measures, what is their expressions?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |