Forum Discussion
Helper IVDisplay Grand total
Hi All,
Please suggest how to show total in view ?
Currently i have days by period and I can not use sum as it will change value by period.
Hi Snagalapur
Based on the issue you've highlighted in the screenshot, it's difficult to fully understand the problem. We kindly request you to share sample data to help us better analyze the situation.
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Thank you for your contribution in enhancing Microsoft Fabric Community Forum.
5 Replies
- burakkaragoz
Super User
Hi Snagalapur ,
To replace all values over 100 with 100 in Power Query, you’ll need to use a custom column instead of the basic Replace Values.
Here’s how:
- Go to Power Query Editor
- Select Add Column > Custom Column
- Use this formula:
if [YourColumn] > 100 then 100 else if [YourColumn] = null then 0 else [YourColumn]
- If you want to overwrite the original column, you can remove it and rename the new one.
This gives you full control over how values are handled — including nulls and anything above 100.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI - pankajnamekar25
Hello Snagalapur
try this measure
Grand Total =
CALCULATE(
SUM('YourTable'[Value]),
REMOVEFILTERS('YourTable'[Period])
)Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
v-aatheequeCommunity Support
Hi Snagalapur
Based on the issue you've highlighted in the screenshot, it's difficult to fully understand the problem. We kindly request you to share sample data to help us better analyze the situation.
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Thank you for your contribution in enhancing Microsoft Fabric Community Forum.- v-aatheeque
Hi Snagalapur
Has your issue been resolved? If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!
