use groupby/ summarize in sumx measure

VilmaBeina — Fri, 30 Aug 2019 06:37:58 GMT

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

Re: use groupby/ summarize in sumx measure

Anonymous — Fri, 30 Aug 2019 09:16:40 GMT

First piece of advice is this:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Second piece of advice is this:
Do not use GRUPBY. Use the combination of ADDCOLUMNS/SUMMARIZE.

Best
D.

topic Re: use groupby/ summarize in sumx measure in DAX Commands and Tips

use groupby/ summarize in sumx measure

Re: use groupby/ summarize in sumx measure