Solved: ISINSCOPE query - Page 2

Anonymous · ‎04-30-2020

Hi,

Could somebody please help me in finishing my ISINSCOPE command?

I need the building name to sum the measure 'Total Bookable Hours' at the end, but it wont accept sum or sumx for the measure of bookable hours.

The Building needs to sum all of the rooms bookable hours on a top level of a matrix. So 400 instead of 200 in the file

PBIX File

Hierarchy = SWITCH(

TRUE(),

ISINSCOPE(

vw1[Room]), [Total Bookable Hours],

ISINSCOPE(

vw1[Building Name]),

))

Thanks

Liam

Anonymous · ‎05-01-2020

// Assuming that
// 1. There is a Building dimension that stores data about buildings.
// 2. There is a Room dimension that stores data about rooms.
// 3. There is a proper Calendar in the model.
// 3. There is a fact table Bookable Hours that for each day stores the bookable
// 	  hours for the relevant combinations of buildings and rooms
//    for each and every day...
// you can write this measure and it'll work correctly without
// any ISINSCOPE.
// Bear in mind that the filtering from dimensions to the fact table
// is one-way.

[Bookable Hours] =
	CALCULATE(
		SUM( 'Bookable Hours'[Hours] ),
		LASTDATE( Calendar[Day] )
	)

Best

D

View solution in original post

ISINSCOPE query

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024