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.
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
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 |
---|---|
42 | |
26 | |
22 | |
13 | |
8 |
User | Count |
---|---|
75 | |
50 | |
47 | |
17 | |
17 |