Forum Discussion

afrutos's avatar
afrutos
Icon for Resolver I rankResolver 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 ...
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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
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.