Forum Discussion
jakaihammuda
Helper III
Helper IIISum Measure outputs into a card visual
Hi, Im having some issues calculating the sum of row totals, the totals provided are calculated from another measure themselves. the column i want to calculate the total sum of is this - and...
hi, jakaihammuda
try belowresult = sumx( filter( all('tablename'), 'tablename'[process column]<>"master" && 'tablename'[process column]<>"validation" ), [process run time] )If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jakaihammudaHelper III
Helper IIIThank you for this! seems to have worked a treat 🙂
one more questyion, if i want to filter so its not "master" and also not "validation" how would i encorporate this into the DAX?
Dangar332
Resident Rockstar
Resident Rockstarhi, jakaihammuda
try below
result =
sumx(
filter(
all('tablename'),
'tablename'[process column]<>"master" && 'tablename'[process column]<>"validation"
),
[process run time]
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- jakaihammuda
Amazing thank you so much for this 😁
- jakaihammuda
Dangar332 - is thre a way to add something to say if the value is blank then replace with a 0?
- Dangar332
hi, jakaihammuda
simply add zero (0) at end of expression
like belowresult = sumx( filter( all('tablename'), 'tablename'[process column]<>"master" && 'tablename'[process column]<>"validation" ), [process run time] ) +0