Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I've below DAX logic for my chart. I've tried but no luck. Can someone help me on this one?
IF
Solved! Go to Solution.
Hi @Anonymous ,
Please create a measure like this.
Measure =
IF (
CALCULATE(
COUNT(CM[Change ID]),
FILTER(
ALLSELECTED('CM'),
CM[Overdue / Not overdue] = "Not Overdue"
)
) < 1 ,
CALCULATE(
COUNT(CM[Change ID]),
FILTER(
ALLSELECTED('CM'),
CM[Overdue / Not overdue] = "Not Overdue" && CM[CMLastMonthYear] = 1
)
) ,
"No Data Message"
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Try this
IF (
CALCULATE(count(CM[Change ID]), SELECTEDVALUE(CM[Overdue / Not overdue]) = "Not Overdue") < 1 ,
CALCULATE(count(CM[Change ID]), SELECTEDVALUE(CM[Overdue / Not overdue]) = "Not Overdue" && SELECTEDVALUE(CM[CMLastMonthYear]) = 1) ,
"No Data Message"
)
Without your data I can't be sure this si what you need.
Regards
Phil
Proud to be a Super User!
Hi,
SelectedValue function in Dax True/False not accepting.
Any other methods to do this? altease with out "No Data message" is possible?
Many thanks for your try 😊.
Hi @Anonymous ,
Please create a measure like this.
Measure =
IF (
CALCULATE(
COUNT(CM[Change ID]),
FILTER(
ALLSELECTED('CM'),
CM[Overdue / Not overdue] = "Not Overdue"
)
) < 1 ,
CALCULATE(
COUNT(CM[Change ID]),
FILTER(
ALLSELECTED('CM'),
CM[Overdue / Not overdue] = "Not Overdue" && CM[CMLastMonthYear] = 1
)
) ,
"No Data Message"
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
If you provided your data and/or PBIX it woudl be easier to work on this.
Try this
IF (
CALCULATE(count(CM[Change ID]), CM[Overdue / Not overdue] = "Not Overdue") < 1 ,
CALCULATE(count(CM[Change ID]), CM[Overdue / Not overdue] = "Not Overdue" && CM[CMLastMonthYear] = 1) ,
"No Data Message"
)
Regards
Phil
Proud to be a Super User!
Hi Philip,
Thanks for your reply. I get below error msg.
For uploading pbix file/Data. I do not see any option to upload. Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |