Forum Discussion

afrutos's avatar
afrutos
Resolver I
4 years ago
Solved

total column table

 

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!

Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

2 Replies