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() )
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() )