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.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

I think my sample does not suit your inquiry. Could you please share your sample pbix file's link (onedrive, googledrive, dropbox, any others) here, and also the desired result, and then I can try to look into it to come up with a more accurate solution.

Thanks.

Balhemkan's avatar
Balhemkan
Helper III
3 years ago

Hi, 

Sorry to bother you. Do you have any update on pbix. I'm completely depending on you. 

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    Thank you for your shring the link.

    I checked your sample, but I am not sure if it looks like below.

     

     

    If so, I think the measure shows the correct number.

    Or, could you please describe what numbers you want to see as a result?

     

    • Balhemkan's avatar
      Balhemkan
      Helper III
      3 years ago

      If one month is selected in slicer then it should be 48355.If two months is selected in slicer then it should be 48355/2 =24177.5 like this

      • 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.