Power Query -

[givenmnisi6]

how can make a measure that counts the number of devices installed each year? 

[dcrosseto]

Hi @givenmnisi6 ,

You can just use a simple COUNT or DISTINCTCOUNT (if IDs repeats), the way you will "aggregate" depends on how you create the visualizations. You can create a single measure that counts the devices and work on the dimensions around it, this will determine how the count will works.

Count All = DISTINCTCOUNT(Data[id])

But of course, you can also specify the aggregation using GROUP BY,

Count by Year = 

CALCULATE(
    DISTINCTCOUNT(Data[id]),
    GROUPBY(Data,Data[year])
)

But if's not gonna change much, what really impacts the results are the viz or dimensions around it, check example below with both measures.

Hope it was helpful!! Also, if solved your problem, please mark as solution to help other as well.

Regards,

Douglas.

[givenmnisi6]

I tried using both of them, ill show you the output.

[Anonymous · Accepted solution]

Hi @givenmnisi6,

These expressin should be used in measure formulas instead of calculated column, or they will be fixed the calculation result to static numbers. (measure are calculated based on filter and row context)

Calculated Columns and Measures in DAX - SQLBI

Row Context and Filter Context in DAX - SQLBI

Regards,

Xiaoxin Sheng