Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Problem is related to If condition which is being applied on Calculated measure and gives absurd result.
Below are the two tables connected through Date Field [Date - Launch Date]
Now I have created a measure which is very simple "Average Measure Without If Condition"=AVERAGE(summary[Volume])
And one slicer "YEAR" added from Date Dim.
Please see below
Filter is working fine so far.
Now I have created one more measure .
Solved! Go to Solution.
Hi again @Anonymous ,
I have tried to reproduce your issue on my own and found better solution where you can keep the Year column coming from the Date_Dim table and avoid the cross-join issue when replacing the blanks for something else.
Issue:
Solution:
Measure:
Average Measure with IF Condition + ISEMPTY =
VAR _Average = [Average Measure Without If Condition]
RETURN
IF (
ISEMPTY ( 'Summary' ),
BLANK (),
IF ( ISBLANK ( _Average ), "TBD", FORMAT ( _Average, "Currency" ) )
)
I hope this helps.
Regards,
Hi again @Anonymous ,
I have tried to reproduce your issue on my own and found better solution where you can keep the Year column coming from the Date_Dim table and avoid the cross-join issue when replacing the blanks for something else.
Issue:
Solution:
Measure:
Average Measure with IF Condition + ISEMPTY =
VAR _Average = [Average Measure Without If Condition]
RETURN
IF (
ISEMPTY ( 'Summary' ),
BLANK (),
IF ( ISBLANK ( _Average ), "TBD", FORMAT ( _Average, "Currency" ) )
)
I hope this helps.
Regards,
@Payeras_BI , Thank you so much for your help 😊 .It is working fine.
Simple if was not working and writing this way solving the problem .Its really wierd.
Hi @Anonymous ,
Does the issue persist when, in your visualization, you remove the column Year coming from your Date_Dim table?
I would create a measure, instead, to get the Year from the Launch Date column.
Year = YEAR(MAX(Summary[Launch Date]))
Let me know the result.
Regards,
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
2 |