Forum Discussion
Solved
DONT SHOW #NUM! in percent profit
Dear friend
I have problem, how I can filter in my formula to don't show #NUM! Of percent profit in pivot table by formula
thank you
Instead of [A]/[B] it's always recommended to use DIVIDE in DAX with third parameter. In you case it could be
% PROFIT:=DIVIDE( [TOTAL PROFIT], [TOTAL COST], blank() )
3 Replies
Is this what you want to do?
- yes, but i wan doing it by formula in data model 'DAX'
Instead of [A]/[B] it's always recommended to use DIVIDE in DAX with third parameter. In you case it could be
% PROFIT:=DIVIDE( [TOTAL PROFIT], [TOTAL COST], blank() )
