Rank x

HI lbendlin , 

Sample Data.xlsx

My data has dates where there are no values so the Stores are always Rank 1 By default 

Thanks , James

lbendlin 

This is the current issue im having , in that it ranking Months that have no usages attached to them so it's Rank 1 for MOnth's that have no data , which is why in above you have 15 rank 1 when there is only 4 Months of Data

It was  not clear to me that tthat is your issue. I thought it was your expected result.

Can you please formulate the ask again?

Sorry lbendlin ,

Essentially a Biref overview 

Emporia Device KP is a conditional column with only the KP stores so i've applied a filter on the page that is not blank so it filters to only KP stores. 

I have a measurement  :

UsagesCount = CALCULATE(COUNTROWS('Emporia Device Usage'))

so i can filter the date table to only include Months that have data , 

New Date Table = CALCULATETABLE('Date',FILTER('Date',[UsagesCount] >= 1 ))

This is a new date table that only has Usages in the data. 

However emporia device usages has other devices with usages before the KP stores so it ranks the Kp stores as rank 1 for the months with no usages but have a usages count higher then 1. 

I'm looking at a way to have the usages count filter the new date table to only include the kp Stores not just any store in the emporia device usages table. 

Something like 

UsagesCount = CALCULATE(COUNTROWS('Emporia Device Usage'), Not ISBLANK('Emporia Devices'[Device name KP]))

but this is not correct 

Thanks , James.