Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Average Distincts per TimeStamp

Hello all.   I'm quite new with Power BI and I'm facing a problem while I try to create a measure.   I have a table with events, its time stamps and the machine with the problem identified with a...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Anonymous,

     

    According to your description, I have made a sample for your reference.

     

    I assume you have a table called "Table1" like below.

     

     

    Then you should be able to use the formula below to create a measure to calculate the average of distinct SN per day in a time frame.

    AvgCountPerDay = 
AVERAGEX (
    SUMMARIZE (
        Table1,
        Table1[Time],
        "DistinctCountOfSN", DISTINCTCOUNT ( Table1[SN] )
    ),
    [DistinctCountOfSN]
)

     

    Here is the sample pbix file for your reference.:smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

According to your description, I have made a sample for your reference.

 

I assume you have a table called "Table1" like below.

 

 

Then you should be able to use the formula below to create a measure to calculate the average of distinct SN per day in a time frame.

AvgCountPerDay = 
AVERAGEX (
    SUMMARIZE (
        Table1,
        Table1[Time],
        "DistinctCountOfSN", DISTINCTCOUNT ( Table1[SN] )
    ),
    [DistinctCountOfSN]
)

 

Here is the sample pbix file for your reference.:smileyhappy:

 

Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Works fine! Many thanks for your time! ;)