Forum Discussion

harrinho's avatar
harrinho
Icon for Helper III rankHelper III
8 years ago
Solved

Rollup % to unique ID level

Hi All,    I have a table which holds unique employee IDs and several other columns attached to them and I use this table to get the ID for every employee and drive the visualization (table) I want...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    Hi harrinho

     

    You may try below measure:

    Rollup % =
AVERAGEX ( SUMMARIZE ( Table2, Table2[ID], Table2[Project] ), [Allocation] )

     

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi harrinho

 

You may try below measure:

Rollup % =
AVERAGEX ( SUMMARIZE ( Table2, Table2[ID], Table2[Project] ), [Allocation] )

 

Regards,

Cherie

harrinho's avatar
harrinho
Icon for Helper III rankHelper III
8 years ago

Therewas an issue with my relationships which is now fixed but unfortunately we are not there yet.

 

So, I managerd to bring in the fwd alloc % on to my Resources table which holds unique ID in a single row. In order to get the count of the IDs which are > 100% in Fwd Alloc, I do the following: 

 



The Over Resources is a Column: 

Over Resoures = IF([Overallocated resources]=1,1,0)

The "Overallocated resources" is a measure:

Overallocated resources = IF([Fwd Alloc]>1,1,0)

 

Apparently the Overallocated resources is the correct one and this is the column count  I want to get, so as to put in in a tree and make it clickable and when you click the tile, the table will only filter thoses with "1". 

 

I don't know why I get 0 in the Over Resources column whwen the Fwd Alloc is clearly > 100%. Maybe it's because I changed the Home Table for Fwd Alloc to the Resources Table  which is where i wanted to live in. I did this manually from Modelling-Home Table. 

 

Isn't there a simple way, even by mocking it up, to get the count of the correct measure ?