Hi My fact table contains multiple rows for the same item every month. I have a measure that sums the total quantity based on when the attribute is Volume UnitsWhat I am looking for is a distinct count of the Product UIN when the product is beansThis is the fact table;
this is what I want (i.e. beans only return 1 per month as there is a distinct count performed on the product UID but the others are just a sum of their quantity
I have tried the following as a calculated column
//Value (Qty adj) =
fact[Attribute] = "Volume Units"
(fact[Product Group] = "Beans"
//followed by a measure;
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.