Show dax measure only for Jan to Jun

[jinivthakkar]

Hi All,

I have a dax which is looks something like this and it is working fine

MyMeasure1 = CALCULATE(
    [Table],
    ref_Dates[Date] >= DATE(2022,1,1),
    ref_Dates[Date] <= DATE(2022,6,30)
)
MyMeasure2 = CALCULATE(
    [Table1],
    ref_Dates[Date] >= DATE(2022,1,1),
    ref_Dates[Date] <= DATE(2022,6,30)
)

MyMeasure3 = MyMeasure1/MyMeasure2

I then use measure 1 and 2 in measure 3 and measure 3 is referred on the visuals and it shows a constant line from Jan to Dec which is as expected and correct but what I want to do is, show measure 3 value only from Jan to Jun and then 0 from Jul to Dec.

I tried adding If condition in measure 3 but it is giving me error.

Please guide/help.

TIA

[jinivthakkar]

@goncalogeraldes thanks for your reply but I am getting error Cannot find name '[Date]':

I also tried a few other ways but nothing seems to work, basically my tables are not populating in the measure.

TIA

[goncalogeraldes]

Hello there @jinivthakkar ! Try the following:

MyMeasure3 =
SWITCH (
    TRUE (),
    MONTH ( SELECTEDVALUE( ref_Dates[Date] ) ) >= 1
        && MONTH ( SELECTEDVALUE( ref_Dates[Date] ) ) <= 6, DIVIDE( MyMeasure1 , MyMeasure2 ),
    0
)

For additional help, please @ me in your reply!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[jinivthakkar]

@goncalogeraldes I tried  this but this gives me a flat line or value as 0, I am not sure if SELECTEDVALUE will work, end users dont have option to select month value.

I already have a bar and line chart and just need to show existing measure only from Jan to Jun without user interaction.

[goncalogeraldes · Accepted solution]

Hey there @jinivthakkar ! In that case you can go with this:

MyMeasure3 =
SWITCH (
    TRUE (),
    MONTH ( MAX( ref_Dates[Date] ) ) >= 1
        && MONTH ( MAX( ref_Dates[Date] ) ) <= 6, DIVIDE( MyMeasure1 , MyMeasure2, 0 ),
    0
)

For additional help, please @ me in your reply!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[jinivthakkar]

@goncalogeraldes Thanks buddy, cheers !!

[goncalogeraldes]

Hi @jinivthakkar ! You can try the following:

MyMeasure3 =
SWITCH (
    TRUE (),
    MONTH ( ref_Dates[Date] ) >= 1
        && MONTH ( ref_Dates[Date] ) <= 6, MyMeasure1 / MyMeasure2,
    0
)

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes