Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

matrix lowest level (rows) taking forever?

I have the below measure where I added the IF clause to avoid negative %:         GM %:=IF( NOT [Net Revenue] < 0 ,DIVIDE( [Gross Margin] ,[Net Revenue]) )           Each respect...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try measures like

 

Gross Margin:=
CALCULATE(
SUM(Revenue[GrossMargin]),
FILTER('Center', NOT(isblank( 'Center'[Department]))
))

 

Net Revenue:=

CALCULATE(
SUM(Revenue[NetRevenue]),
FILTER('Center', NOT(isblank( 'Center'[Department]))
))

 

GM %:=IF( [Net Revenue] > 0
,DIVIDE( [Gross Margin] ,[Net Revenue]) , blank()
)

 

Unless you want Net Revenue > 0, do not use if. divide is good enough to handle 0