wrong dates in line chart

[bhelou]

Dear , I have this measure for the Balances the measure giving correct resutls in table but when making as a line chart and puting the dates , the value is correct but the dates are showing till the end of the dates table that i have .
* I have dates table its all correct 
* i have made future month filter measure so i can select the true dates the falls in the normal calendar no need for future dates 
this is the dates filter that im using in the report directrly 

this dates measure is correct in all reports .

Kindly help me in the Measure below ( knowing that its giving correct results in tables and matrix but when making a chart line its giving dates to the end date table i have ) , i think its from the ALL ( '*Dates' ) filter below in the mesaure  , i remved All filter but gave me wrong result when removing all filter from the date . Kindly help if possible  

AP_TRIAL_BALANCE_OPENNING_BALANCE =

VAR Openning_Debit =

CALCULATE (

[AP_TRIAL_BALANCE_DEBIT],

FILTER (

ALL ( '*Dates' ),

'*Dates'[Date]

< MIN ( '*Dates'[Date] )

)

) * -1

VAR Openning_Credit =

CALCULATE (

[AP_TRIAL_BALANCE_CREDIT],

FILTER (

ALL ( '*Dates' ),

'*Dates'[Date]

< MIN ( '*Dates'[Date] )

)

) * -1

VAR Openning_Balance = Openning_Debit - Openning_Credit

RETURN

CALCULATE(

IF (

ISBLANK ( Openning_Balance ),

0,

Openning_Balance

))

[PVO3 · Accepted solution]

It's hard to guess. Buyt you could try something like this.

AP_TRIAL_BALANCE_OPENNING_BALANCE =
VAR Openning_Debit =

CALCULATE (
[AP_TRIAL_BALANCE_DEBIT],
FILTER (
ALL ( '*Dates' ),
'*Dates'[Date] < MIN ( '*Dates'[Date] )
)
)

VAR Openning_Credit =

CALCULATE (
[AP_TRIAL_BALANCE_CREDIT],
FILTER (
ALL ( '*Dates' ),
'*Dates'[Date] < MIN ( '*Dates'[Date] )
)
)

VAR Openning_Balance = Openning_Debit - Openning_Credit

RETURN

CALCULATE(
IF (
ISBLANK ( Openning_Balance ) && MAX(fact table[date]) <= MAX('*Dates'[Date]),
0,
FORMAT(Openning_Balance, -0.000)
)
)

[bhelou · Accepted solution]

Thank you  very much it worked 
CALCULATE(
IF (
ISBLANK ( Openning_Balance ) && MAX(fact table[date]) <= MAX('*Dates'[Date]),
0,
FORMAT(Openning_Balance, -0.000)
)
)

[PVO3 · Accepted solution]

It's hard to guess. Buyt you could try something like this.

AP_TRIAL_BALANCE_OPENNING_BALANCE =
VAR Openning_Debit =

CALCULATE (
[AP_TRIAL_BALANCE_DEBIT],
FILTER (
ALL ( '*Dates' ),
'*Dates'[Date] < MIN ( '*Dates'[Date] )
)
)

VAR Openning_Credit =

CALCULATE (
[AP_TRIAL_BALANCE_CREDIT],
FILTER (
ALL ( '*Dates' ),
'*Dates'[Date] < MIN ( '*Dates'[Date] )
)
)

VAR Openning_Balance = Openning_Debit - Openning_Credit

RETURN

CALCULATE(
IF (
ISBLANK ( Openning_Balance ) && MAX(fact table[date]) <= MAX('*Dates'[Date]),
0,
FORMAT(Openning_Balance, -0.000)
)
)

[bhelou · Accepted solution]

This is the working Variab;e , Thanks , 

CALCULATE (

IF (

ISBLANK ( Openning_Balance ) && NOT ( ISBLANK ( COUNTROWS ( '*Dates' ) ) ),

0,

Openning_Balance

)

)

[bhelou · Accepted solution]

Thank you  very much it worked 
CALCULATE(
IF (
ISBLANK ( Openning_Balance ) && MAX(fact table[date]) <= MAX('*Dates'[Date]),
0,
FORMAT(Openning_Balance, -0.000)
)
)

[PVO3]

Hi,

You should remove the * -1 at the end of your variables.

Perhapse change this to something like below (depending on regional preferences).

FORMAT ([measure] , -0.000) 

[bhelou]

Dear , 

i Made it like this but gave me error couldnt display any visiual 

AP_TRIAL_BALANCE_OPENNING_BALANCE =

VAR Openning_Debit =

FORMAT(

CALCULATE (

[AP_TRIAL_BALANCE_DEBIT],

FILTER (

ALL ( '*Dates' ),

'*Dates'[Date]

< MIN ( '*Dates'[Date] )

)

),-0.000)

VAR Openning_Credit =

FORMAT(

CALCULATE (

[AP_TRIAL_BALANCE_CREDIT],

FILTER (

ALL ( '*Dates' ),

'*Dates'[Date]

< MIN ( '*Dates'[Date] )

)

),-0.000)

VAR Openning_Balance = Openning_Debit - Openning_Credit

RETURN

CALCULATE(

IF (

ISBLANK ( Openning_Balance ),

0,

Openning_Balance

))

formating it didnt work 

[bhelou]

Dear , 

I have removed the if condition ( is blank  ) but in the visual card is giving me blank now i need it 0 ...

CALCULATE(

IF (

ISBLANK ( Openning_Balance ),

0,

Openning_Balance

))