Change Line color based on previous quarter

[Anonymous]

Hi, I have calculated column:

Quarter = QUARTER('tableXXX'[Date])

then I want to create two lines: one(red) if the current quarter is less than previus and second line (green) if current quarter is more than previus. 

I create two measure current quarter:

cq = CALCULATE(Sum('tableXXX'[CurrentNumber]) / Sum('tableXXX'[Total Possible Number]),

     'tableXXX'[Type]="SpecificType", 'tableXXX'[Quarter]=QUARTER(TODAY()))

and previus quarter:

cq = CALCULATE(Sum('tableXXX'[CurrentNumber]) / Sum('tableXXX'[Total Possible Number]),

     'tableXXX'[Type]="SpecificType", 'tableXXX'[Quarter]=QUARTER(TODAY()) -1)

My lines are : 

DownLine = if( [cq] <[pq] , [Measure%], BLANK() )

UpLine = if( [cq] >[pq] , [Measure%], BLANK() )

Measure% = CALCULATE(

     ( Sum('tableXXX'[CurrentNumber]) / Sum('tableXXX'[Total Possible Number])),

     'tableXXX'[ype]="SpecificType")

Problem: if I use two measures in if statement for example pq and cq  later the line chart dont show line, its only show one quarter. If I use at least one number for example pq>5 then line chart show correctly all quarters on the chart.

I suspect that is something with context but I dont know how to resolve this pre

[Anonymous]

I followed thanks

[PaulDBrown]

Please follow the recommendations in this thread to help us help you:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523