After add Vari % my table become very long list

[admin11]

Hi All

i have a Rev table below working fine :-

I like to add the Vari % for above Table , i have try to create the expression below  , it work fine :-

_Vari_%_REV = if(isblank( divide(

[_YTD REV]

-

[_LYTD REV]

,

[_LYTD REV]

)),1, divide(

[_YTD REV]

-

[_LYTD REV]

,

[_LYTD REV]

))

But the Table become very long :-

My PBI file :-

https://www.dropbox.com/s/9161ueru5hiwgvy/PBT_V2021_400%20GL_TI.pbix?dl=0

Paul

[amitchandak · Accepted solution]

@admin11 , add a addition if at start

if( isblank([_YTD REV]) && isblank([_LYTD REV]) , blank() ,  <your if> )