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.
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 @Matt_manderA ,
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 @Matt_manderA ,
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.
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.