How to calculate distinct dax data in period when periodly meets not same data

[adiletsh]

Hello everyone


I've used in formula distinct dax to calculate Daily data. And I was given a task to get data in a period. In a period distinct data not working because there meets not same data like in a daily data. Visualization filters by data and unique elements. 

the formula looks like this: 

var _density_min = _heads_min / DISTINCT('Table'[column])

_heads_min    calculates sum of quantity, and I need to divide to distinct value. In a period I took data for a month or more and there probably meets two distinct value like (1920, 1890). Each day has its own unique distinct value.


So,  my problem is calculate this value in a period.


Thank you in advance

[amitchandak]

@adiletsh ,

You can try like

Averagex(Values(Table[Period]), calculate(_heads_min) )

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[adiletsh]

To explain my problem:

I had use this formula : var _density_min = _heads_min / DISTINCT('Table'[column]). It works only for daily data. 

So, I need to calculate data with this formula in a period. But it's not working. because in a period in  'Table'[column]  meets different values


Сould I explain it more clearly?