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 el...
rubayatyasmin
Community Champion
Community ChampionHi, 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