Calculate measure with filter items and nonfiltered items

[mmachacek]

Hello, everyone,

I have a problem with this measure and I can't find the right answer.

We sell equipment and consumables.

My goal is to calculate the ratio of equipment and consumables versus time.
This works well for all time. But if I filter data with another visual to a specific time period I need all older device in the measure.

Please look at the picture bellow.

Measure =all consutables in filtered area divide all devices that are older or in the filtered area.

Could you please help me, thank you very much.
Martin

[V-lianl-msft · Accepted solution]

Try to create measure like below:

Measure = 
var filtered_ = COUNT('Table'[device])
var all_ = CALCULATE(COUNT('Table'[device]),FILTER(ALL('Table'),'Table'[Date]<MIN('Table'[Date])))
return DIVIDE(filtered_,all_)

[mmachacek]

Hello @V-lianl-msft ,

thank you, this solution works.

But how to added another filter to this, for example filter for device manufacturer?
If I tried I still have all date, based on ALL date formula in meassure.

Thank you.
Martin

[AllisonKennedy]

@mmachacek 

Try this measure and then use for your divide: 

All Devices Older or In Filtered Area = 

CALCULATE( [Devices Count], ALL(DimDate), DimDate[Date] <= MAX(DimDate[Date]))