Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Hierarchy help

Hi,   Im just wondering if there's possibly a function that would help total up however many lower levels there is in a hierarchy e.g. Building name below and display the total (400).   The reaso...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Anonymous 

    It looks like the same thread there.

    So I directly tested the pbix  you  provide there.

    It is unreasonable to establish relationship between tables through the field "Date" and  "Start date"

     

    Through your original formula, I guess  you may just want to get the result of   [count of  all working days in the date] * 10.

    If it is ,  try  this measure as below:

    Measure = 
SUMX(GROUPBY('Bookings','Bookings'[Building Name],'Bookings'[Room]),COUNTROWS(FILTER(DISTINCT('Bookings'[Start Date]),WEEKDAY([Start Date],2) IN {1,2,3,4,5})) *10 )

    pbix attached 

     

    Best Regards,
    Community Support Team _ Eason

     

     

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , Anonymous 

It looks like the same thread there.

So I directly tested the pbix  you  provide there.

It is unreasonable to establish relationship between tables through the field "Date" and  "Start date"

 

Through your original formula, I guess  you may just want to get the result of   [count of  all working days in the date] * 10.

If it is ,  try  this measure as below:

Measure = 
SUMX(GROUPBY('Bookings','Bookings'[Building Name],'Bookings'[Room]),COUNTROWS(FILTER(DISTINCT('Bookings'[Start Date]),WEEKDAY([Start Date],2) IN {1,2,3,4,5})) *10 )

pbix attached 

 

Best Regards,
Community Support Team _ Eason

 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-easonf-msft ,

 

My apologies, I thought it had been deleted. Thankyou so much for your time and the measure.

 

Regards

 

Liam