Forum Discussion
Hide the total value from a column
Hi there.
In my table I have some columns with a percentage value divided by weeks:
The total rows is correcly the sum of all the rows.
The column "%Delta" is the difference between the most recent week and the less recent one. In this scenario, the total that you see (2.64%) is not correct because I should see 1.16%. 2.64 is the sum of all the differences of my rows.
There is a way to hide that value or to correct it?
What you see in the columns is this:
%Deltascrap_week = IF(ISINSCOPE(DateTable[week]),BLANK(), SAPProdScrapCalc[Delta%ScrapDesc_week])
and Delta%ScrapDesc_week is calculated by:
Delta%ScrapDesc_week =
VAR PercMaxWeek= if(MAX(DateTable[week]) > DateTable[ThisWeek],calculate(SAPProdScrapCalc[%scrapDesc], FILTER(DateTable,DateTable[week]=DateTable[ThisWeek])),calculate(SAPProdScrapCalc[%scrapDesc], FILTER(DateTable,DateTable[week]=MAX(DateTable[week]))))
VAR PercMinWeek = calculate(SAPProdScrapCalc[%scrapDesc], FILTER(DateTable,DateTable[week]=MIN(DateTable[week])))
RETURN
PercMaxWeek-PercMinWeek
Indeed the colums "%delta" of my weeks are hidden, I just need the total of this measure.
andreazambon , You need have delta like
example like
This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))diff % = divide([This week] -[Last week], [Last week])
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
1 Reply
- amitchandak
Super User
andreazambon , You need have delta like
example like
This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))diff % = divide([This week] -[Last week], [Last week])
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510