Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I'm facing a weird issue
I have a table grouped table at Order Level where I've throwed in a set of KPIs to analyze if a Order should be submitted in the system or not. Nothing to say till, I've added the following measure:
Order Status =
VAR one_ = [1. % Order Value (100%)] -- Threshold 100%
VAR two_ = [2. (0%)] -- Threshold 0%
VAR four_ = [4. ] -- Threshold >= 3%
VAR six_ = [6. ] -- Threshold <= 2%
RETURN
IF (
one_ < 1
|| two_ > 0
|| four_ < 0.03
"Declined",
"Authorized"
)
Now Power BI is duplicating each Order by the number of Countries that we have in system(The order only exists on Ivory Coast)
Any idea of what might be happening? Without the Order Status, the Dashboard works great without any relationship issue.
Thanks
Diego
Looks like you've got missing relationships between some tables...
Hello,
No missing relationship.. Look below:
With the measure below that performs a logical condition based on Measure 1.
Order Status =
VAR one_ = [1.] -- Threshold 100%
RETURN
IF (one_ < 1,"Declined","Authorized")
Any idea on what might be the root cause of this?
Thanks Diego
Hello
Any idea on how to resolve this cross join between non related variables?
Thanks a lot
Hi, @carlovsky
You may need to take blank values into account, try the formula below if it works.
Order Status =
VAR one_ = [1.] -- Threshold 100%
RETURN
IF ( one_ = BLANK (), BLANK (), IF ( one_ < 1, "Declined", "Authorized" ) )
Best Regards,
Community Support Team _ Eason