The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi guys,
I am really struggling with this one. I have a matrix like the one below and I am trying to calculate for every single line Size 1 Stock divided by Size 1 IAQ. However, when I use the DIVIDE function, it gives me very strange %'s. I also need this to be dynamic depending on what is selected on the slicer (Online Channel).
Any help is very much apprecaited.
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
Or like this?
Measure 2 =
DIVIDE(
SUMX(
FILTER( table, table[column] = "Size 1 Stock" ),
table[value]
),
SUMX(
FILTER(
table, table[column] = "Size 1 IAQ"
),
table[value]
)
)
If not please show me the .pbix file or sample data.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Or like this?
Measure 2 =
DIVIDE(
SUMX(
FILTER( table, table[column] = "Size 1 Stock" ),
table[value]
),
SUMX(
FILTER(
table, table[column] = "Size 1 IAQ"
),
table[value]
)
)
If not please show me the .pbix file or sample data.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
36 | |
15 | |
12 | |
11 | |
9 |
User | Count |
---|---|
46 | |
44 | |
19 | |
18 | |
18 |