Forum Discussion
Removing Totals on filtered data
Hi all,
I am trying to remove a total which is showing misleading information,
When the data is filtered, or when it is not, the total columns marked below show the last Month / Quarter Total,
Ideally I would like to hide that total until a month is selected, or alternatively by default show the current months data
10 Replies
- amitchandak
Super User
HanishR , if you have used If in your formula, try to change that to filter.
Or force row context like this
sumx(summarize(Table,Table[class], table[country],"_1",[Budget]),[_1])Please Watch/Like/Share My webinar on Time Intelligence: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
My Your Tube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy
Appreciate your Kudos.- I have not used any formulas in this matrix,
it is purely sum of Budget
sum of sales
and then there's measures as needed for % of budget and % Growth.- amitchandak
HanishR , These MTD, QTD, YTD are filter using relative date or some formula ?
- Icey
Community Support
Hi HanishR ,
It is best not to use quick measure. Create your measure like so:
MTD = TOTALMTD(SUM(Sales[Sales]),'Date'[Date])Or just change your quick measure like so:
Sales MTD = IF( ISFILTERED('Date'[Date]), ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."), TOTALMTD(SUM('Sales'[Sales]), 'Date'[Date]) ---------.[Date] is deleted. )Then, the total will show the value of max month if no specific month is selected.
BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Yes, Thank you.
