Forum Discussion
Hierarchy help
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 )Best Regards,
Community Support Team _ Eason
Anonymous , refer if this can help
https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/
Hi amitchandak ,
Thanks for your reply. This article relies on the measure summing upwards naturally which unfortunately my measure doesnt do.
Thanks
Liam
Hi amitchandak ,
Thanks again for replying. They are all using the SUM function from the same table which I'm unfortunately not.
I'm not sure whether its possible, as if I use the isfiltered or isinscope it will always equal the same total as the lower level. I was hoping of an alternative approach where it could total the lower level on the fly