Forum Discussion

thomazinh's avatar
thomazinh
Icon for Helper I rankHelper I
4 years ago
Solved

What If parameter matrix subtotal mismatch

Hierarchy values in my matrix are not returning the correct subtotal values when calling out a What If parameter. Here is a link to my sample PBI file.    For example, for Arch AAA should total to ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi thomazinh ,

     

    Modify _Selected Bid as below.

    _Selected Bid = 
VAR ShowSelected = 
SWITCH(TRUE(),
    CONTAINSSTRING( SELECTEDVALUE(Table4[WbsCode]), "AAA"), SELECTEDVALUE(Parameter_AAA[Parameter_AAA]),
    CONTAINSSTRING( SELECTEDVALUE(Table4[WbsCode]), "BBB"), SELECTEDVALUE(Parameter_BBB[Parameter_BBB]),
    CONTAINSSTRING( SELECTEDVALUE(Table4[WbsCode]), "FFF"), SELECTEDVALUE(Parameter_FFF[Parameter_FFF]),
    SELECTEDVALUE(Table4[Bid Value])
    )
RETURN
if(ISINSCOPE(Table4[WbsCode]),ShowSelected,0)

     Then create a new measure.

    Measure = SUMX(Table4,[_Selected Bid])

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi thomazinh ,

 

Modify _Selected Bid as below.

_Selected Bid = 
VAR ShowSelected = 
SWITCH(TRUE(),
    CONTAINSSTRING( SELECTEDVALUE(Table4[WbsCode]), "AAA"), SELECTEDVALUE(Parameter_AAA[Parameter_AAA]),
    CONTAINSSTRING( SELECTEDVALUE(Table4[WbsCode]), "BBB"), SELECTEDVALUE(Parameter_BBB[Parameter_BBB]),
    CONTAINSSTRING( SELECTEDVALUE(Table4[WbsCode]), "FFF"), SELECTEDVALUE(Parameter_FFF[Parameter_FFF]),
    SELECTEDVALUE(Table4[Bid Value])
    )
RETURN
if(ISINSCOPE(Table4[WbsCode]),ShowSelected,0)

 Then create a new measure.

Measure = SUMX(Table4,[_Selected Bid])

 

Best Regards,

Jay