Forum Discussion

andreazambon's avatar
andreazambon
Icon for Helper V rankHelper V
3 years ago
Solved

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.

1 Reply