Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 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.
I have two columns I need to compare, one column: 'MOM Stocking Report': Shows all stocked items & 'Demand Seg': Shows the complete list of purchased items.
I need to compare them against one another to know which ones are stocked and which are not.
As you can see the equation below, it appears to get me halfway there as the pie chart does capture the data, however I am not certain this is correct, Also when I click on the 'YES' stocked pie chart, the table shows nothing. Also, technically the 'Agreement Level' should be a 0 if 'Not Stocked' or come back with null.
My relationship cardinality is at Many to Many , it wont let me change- I have removed all duplicates from Power Query. So I am basically out of ideas:
My Stock or Not Equation:
Hi @TylerVono
Please try
Stocking Agreement? =
IF (
ISEMPTY (
FILTER (
RELATEDTABLE ( 'MOM Stocking Report' ),
'MOM Stocking Report'[Item Number] = 'Demand Seg'[ITEM NUMBER]
)
),
"YES",
"NO"
)
Hi There Tamerj1, I tried the equation and the same thing happens, the 'YES' result will not show up on the table, I dont think they're comparing against one another. See below, do you have any other ideas? I have a Many to Many cardinality for 'Item Number', it says there are duplicates but as you can see I removed them:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
9 |
User | Count |
---|---|
17 | |
14 | |
13 | |
13 | |
12 |