Power BI - DAX

[nishak323]

Hi ,looking for a help to calculate total on each row by ignoring strings at power bi (DAX) 

data:

expected:

Tried the below measure just for one column but since am using filter, its eliminating the rows which contain SL but i required remaining data totals just by ignoring particular strings(cell value)

Measure =

var data = SUMX(FILTER(Append1, Append1[7/6/2023]<>"SL"), VALUE(Append1[7/6/2023]))

return data

looking for suggestions!!

[rubayatyasmin]

Hi, @nishak323 

Try to use isnumber function. for example:

Total =
IF(ISNUMBER([Monday]), [Monday], 0) +
IF(ISNUMBER([Tuesday]), [Tuesday], 0) +
IF(ISNUMBER([Wednesday]), [Wednesday], 0)

here is the documentation for ISNUMBER DAX function. ISNUMBER function (DAX) - DAX | Microsoft Learn