Forum Discussion
Power BI - DAX
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!!
1 Reply
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
