Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Grand Total when using IsInScope?

I have the below measure:         VAR VParent = FILTER ( SUMMARIZE ( Revenue, 'Customer'[Parent], 'Cost'[Business] ), [Measure1] > 0 ) VAR MaxParent = MAXX ( VParent, [Measure1] ) VAR...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try

     

    SWITCH (
    TRUE (),
    ISINSCOPE ( 'Customer'[Customer] ), DIVIDE ( SubT, MaxParent ),
    ISINSCOPE ( 'Customer'[Parent] ), DIVIDE ( SubT, MaxParent ),
    ISINSCOPE ( 'Leads'[Emp] ), DIVIDE ( SubTotal_Leads, Max_Leads ),

    not(ISINSCOPE ( 'Customer'[Customer] ) || ISINSCOPE ( 'Customer'[Parent] ) || ISINSCOPE ( 'Leads'[Emp] )) , DIVIDE ( SubT, MaxParent )
    BLANK ()
    )


    or


    AverageX(summarize(Fact, 'Customer'[Customer],'Customer'[Parent] ,'Leads'[Emp], "_1" ,
    SWITCH (
    TRUE (),
    ISINSCOPE ( 'Customer'[Customer] ), DIVIDE ( SubT, MaxParent ),
    ISINSCOPE ( 'Customer'[Parent] ), DIVIDE ( SubT, MaxParent ),
    ISINSCOPE ( 'Leads'[Emp] ), DIVIDE ( SubTotal_Leads, Max_Leads ),
    BLANK ()
    )),[_1])

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try

 

SWITCH (
TRUE (),
ISINSCOPE ( 'Customer'[Customer] ), DIVIDE ( SubT, MaxParent ),
ISINSCOPE ( 'Customer'[Parent] ), DIVIDE ( SubT, MaxParent ),
ISINSCOPE ( 'Leads'[Emp] ), DIVIDE ( SubTotal_Leads, Max_Leads ),

not(ISINSCOPE ( 'Customer'[Customer] ) || ISINSCOPE ( 'Customer'[Parent] ) || ISINSCOPE ( 'Leads'[Emp] )) , DIVIDE ( SubT, MaxParent )
BLANK ()
)


or


AverageX(summarize(Fact, 'Customer'[Customer],'Customer'[Parent] ,'Leads'[Emp], "_1" ,
SWITCH (
TRUE (),
ISINSCOPE ( 'Customer'[Customer] ), DIVIDE ( SubT, MaxParent ),
ISINSCOPE ( 'Customer'[Parent] ), DIVIDE ( SubT, MaxParent ),
ISINSCOPE ( 'Leads'[Emp] ), DIVIDE ( SubTotal_Leads, Max_Leads ),
BLANK ()
)),[_1])