Hide the total value from a column

[andreazambon]

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.

[amitchandak · Accepted solution]

@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-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510