Forum Discussion

chfio's avatar
chfio
Regular Visitor
9 years ago
Solved

Daily average

1) I have a dates column..example 1each    Dates  1          3/5/2017  1          3/5/2017 ---- 2 instances on 3/5  1          3/9/2017  1          3/9/2017  1          3/9/2017  1          3/...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    Hey,

     

    unfortunately calculated tables used in the data model and not as a filter or input for other functions do not update depending on changes in a slicer selection, this is by design.

     

    I created a little Power BI file that uses this measure

    average no of rows per day = 
var maxSelectedDate = ALLSELECTED('Table1'[Date])
return
AVERAGEX(maxSelectedDate
	,CALCULATE(count('Table1'[RowID]))
)

    this measure can used on card visual, the following screenshot shows that there are an average number of rows of 2.5 for both selected days (4 from 28th of August and 1 from 1st of September.

     

    Hope this is what you're looking for.

     

    Regards

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

unfortunately calculated tables used in the data model and not as a filter or input for other functions do not update depending on changes in a slicer selection, this is by design.

 

I created a little Power BI file that uses this measure

average no of rows per day = 
var maxSelectedDate = ALLSELECTED('Table1'[Date])
return
AVERAGEX(maxSelectedDate
	,CALCULATE(count('Table1'[RowID]))
)

this measure can used on card visual, the following screenshot shows that there are an average number of rows of 2.5 for both selected days (4 from 28th of August and 1 from 1st of September.

 

Hope this is what you're looking for.

 

Regards