Count values generated by measure across dates table.

[vaibhavd]

I have following measure that calculates the version accross dates (displayed in green below).

Version =
VAR endOfMonthDate = ENDOFMONTH(Dates[Date])
VAR startOfMonthDate = STARTOFMONTH(Dates[Date])
VAR lastDate_ = CALCULATE(LASTDATE('Upgrade_Data'[UpgDate]),
'Upgrade_Data'[UpgDate]<=endOfMonthDate,
CUSTOMERS[LEAVE_DATE] >= startOfMonthDate || CUSTOMERS[LEAVE_DATE] = BLANK())
return
CALCULATE(
[MaxCustomBranch],
'Upgrade_Data'[UpgDate] = lastDate_
)

Now I want to have following output.

I have spent quite some time on it. But not able to count the values generated by measure. Can anyone please help ?

[Mariusz]

Hi @vaibhavd 

If you want to use a version in your Matrix as a Column or Row then you will need to add it as a column to your table.

If this is not what the problem is, please can you attempt to explain it again?

Thanks

Mariusz

[az38]

Hi @vaibhavd 

not sure thi is you are looking for but try a measure like

Measure = 
var countCustomer = calculate(count(Table1[Customer]))
return
if(isblank(countCustomer);0;countCustomer)

it could give you a desired matrix

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

[vaibhavd]

Please help me on this.