Forum Discussion

Mani_ms's avatar
Mani_ms
Helper I
6 years ago
Solved

Comparing Two period slicer selection

Hi ,   I have months under slicer and i want to arrive difference between two selected period based on the selection. (Based on the latest month selcted and selected previous period)   Arriving ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Mani_ms ,

    I found that you filtered the group = BS in the matrix so I created a slicer for the group field and the following measure if I got it correctly:

    Measure = 
VAR _group =
    SELECTEDVALUE ( 'FMA 011 CY'[Group] )
VAR _maxfis =
    CALCULATE (
        MAX ( 'FMA 011 CY'[Fiscal Year/Period] ),
        ALLSELECTED ( 'FMA 011 CY'[Fiscal Year/Period] )
    )
VAR _minfis =
    CALCULATE (
        MIN ( 'FMA 011 CY'[Fiscal Year/Period] ),
        ALLSELECTED ( 'FMA 011 CY'[Fiscal Year/Period] )
    )
VAR _max =
    CALCULATE (
        SUM ( 'FMA 011 CY'[Balance - Cumulative] ),
        'FMA 011 CY'[Group] = _group,
        'FMA 011 CY'[Fiscal Year/Period] = _maxfis
    )
VAR _min =
    CALCULATE (
        SUM ( 'FMA 011 CY'[Balance - Cumulative] ),
        'FMA 011 CY'[Group] = _group,
        'FMA 011 CY'[Fiscal Year/Period] = _minfis
    )
RETURN
    _max - _min

    Attached sample file: fille.pbix 

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi Mani_ms ,

Try like this measure:

Diff =
VAR _max =
    CALCULATE ( MAX ( 'Table'[Sales] ), ALLSELECTED ( 'Table'[Month] ) )
VAR _min =
    CALCULATE ( MIN ( 'Table'[Sales] ), ALLSELECTED ( 'Table'[Month] ) )
RETURN
    _max - _min

 

Attached a sample file that hopes to help you: Comparing Two period slicer selection.pbix

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • Mani_ms's avatar
    Mani_ms
    Helper I
    6 years ago

    Hi, 

     

    Thanks for your inputs, seems somehow i am missing the expected result. attached PBI file 

     

    Expected result

    would be great if you could help on this?

    Thanks,

    Mani

     

    • Mani_ms's avatar
      Mani_ms
      Helper I
      6 years ago

      Hi, 

       

      Thanks for your input.

      Its working for the Max and Min values and difference is am getting wrong number. 

       

       

    • v-yingjl's avatar
      v-yingjl
      Community Support
      6 years ago

      Hi Mani_ms ,

      Not certain how did your expected output calculate, for each group and slected month?

      Could you please sharing a dummy .pbix file for further discussion? Remeber to replace the sensitive information in the file.

       

      Best Regards,
      Yingjie Li

      If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

      • Mani_ms's avatar
        Mani_ms
        Helper I
        6 years ago

        v-yingjl  Thanks for your input.

         

        I am new to community , How to upload files in the community portal. i have business one drive there i can't share the information outside. could you pls suggest alernate way.