Hello,
I'm new in Power BI, so I need help to write dax measure 🙂
I have table Disconnections (with a lot of disconnections (Disc_ID), there are a lot of disconnected customers (OBJ_ID), they appear several times in one disconnection, and customers (Disc_Power). From this table, I need to find the Disc_Power value for each customer (OBJ_ID) in each disconnection (Disc_ID) and then divide it by total all my customers Power, which is in another dimension table Object (Customers (OBJ_ID) and theirs (Power).)
These two tables are connected with OBJ_ID key.
Nepl_ASIFI_ALL =
DIVIDE(
sumx(
GROUPBY(Disconnections ;
Disconnections [Disc_ID];
Disconnections [OBJ_ID];
"OBJ_Power"
Disconnections [Disc_Power]);
sumx(
FILTER('Object';
'Object '[valid till]=BLANK());
'Object'[Power]
))
So there is a mistake with bolded part, could anyone help me by fixing it? 🙂
Thanks in advance, Vilma
