Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

powerbi desktop

 
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have also replaced the country of A(india ) to A(USA) on 06/01/19

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Net variance is coming wrong by selecting groups in slicer

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi, Anonymous 

     

    You may try the following measure to see if it works.

    Actual varaince = 
var _comparetab =
CALCULATETABLE(
    DISTINCT('Table'[Dimension]),
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Date]=SELECTEDVALUE('Compare Date'[Date])
    )
)
var _basetab = 
CALCULATETABLE(
    DISTINCT('Table'[Dimension]),
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Date]=SELECTEDVALUE('Base Date'[Date])
    )
)
var _result = 
COUNTROWS(
    FILTER(
        _basetab,
        NOT([Dimension] in _comparetab)
    )
)
return
IF(
    HASONEVALUE('Base Date'[Date])&&HASONEVALUE('Compare Date'[Date]),
    IF(
        ISBLANK(_result),
        0,
        _result
    )
)

     

    Best Regards

    Allan

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

      Thanks for your help but its not working while comparing 1/1/19 and 6/1/19 its giving different value when selecting india and usa as countries