Forum Discussion

Balhemkan's avatar
Balhemkan
Helper III
3 years ago
Solved

Sum and average based on selection

Hello Team,    I need your help on below issue. Please help me   I am using date slicer (start date and end date) in my dashboard   my problem is, If i select only one month in slicer it shou...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Balhemkan ,

    The measure calculates based on the date column. There is no date on the card so that it is blank. You can use KPI visual to show.

     

    Or use another measure in the card.

    Measure2 =
VAR _min =
    MIN ( 'Table'[Date] )
VAR _max =
    MAX ( 'Table'[Date] )
VAR _sales =
    CALCULATE (
        SUM ( volume[Sales] ),
        FILTER ( volume, volume[month] = MONTH ( _min ) )
    )
VAR _diff =
    DATEDIFF ( _min, _max, MONTH ) + 1
RETURN
    _sales / _diff

    Best Regards

    Community Support Team _ Polly

     

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Balhemkan ,

Please refer to my pbix file to see if it helps you.

Best Regards

Community Support Team _ Polly

 

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

Balhemkan's avatar
Balhemkan
Helper III
3 years ago

This is not working on card visual and it showing blank. Could you please suggest me

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Balhemkan ,

    The measure calculates based on the date column. There is no date on the card so that it is blank. You can use KPI visual to show.

     

    Or use another measure in the card.

    Measure2 =
VAR _min =
    MIN ( 'Table'[Date] )
VAR _max =
    MAX ( 'Table'[Date] )
VAR _sales =
    CALCULATE (
        SUM ( volume[Sales] ),
        FILTER ( volume, volume[month] = MONTH ( _min ) )
    )
VAR _diff =
    DATEDIFF ( _min, _max, MONTH ) + 1
RETURN
    _sales / _diff

    Best Regards

    Community Support Team _ Polly

     

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

  • Balhemkan's avatar
    Balhemkan
    Helper III
    3 years ago

    It really works. 

    Thank a lot