total column table

[afrutos]

Hi everyone,
I have a question here.
I would like to know if i can change the format of a total in a column.
I just want the total for "Remanente" column and for "Pago Pendiente" but not for the others.
I know i can use a text field coloured in white, but this is not the solution i want, because if I filter by a Year, my table is smaller so the text field won't be useful here. 

Thanks in advanced!

[v-yalanwu-msft · Accepted solution]

Hi, @afrutos ;

If you create the measure by dax ,you could use sum() or ISINSCOPE().

Here i use sum 

pagado = 
VAR  _SUM= CALCULATE(SUM([importeAprobado])-SUM([Importe Pagado ]),FILTER('Table',[cate]="A"))
RETURN IF(_SUM=BLANK(),0,_SUM)

remanen = 
VAR  _SUM= CALCULATE(SUM([importeAprobado])-SUM([Importe Pagado ]),FILTER('Table',[cate]="B"))
RETURN IF(_SUM=BLANK(),0,_SUM)

The final output is shown below:

Or use:

IF(ISINSCOPE('Table'[cate])

if not right,can you share me a simple file and the output what you want  ?
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@afrutos , isinscope , isfiltered and hasonevalue can help in getting access to grand total. But I doubt you can change the format without making it as text

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/