Forum Discussion
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...
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 / _diffBest 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.
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.
It really works.
Thank a lot