The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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
@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
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
@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.
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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
57 | |
32 | |
20 | |
17 | |
15 |
User | Count |
---|---|
56 | |
31 | |
30 | |
24 | |
21 |