Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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, @Anonymous
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
26 | |
17 | |
12 | |
12 | |
10 |
User | Count |
---|---|
33 | |
25 | |
16 | |
14 | |
13 |