topic Re: Count values generated by measure across dates table. in DAX Commands and Tips

Count values generated by measure across dates table.

vaibhavd — Thu, 26 Dec 2019 06:58:55 GMT

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 ?

Re: Count values generated by measure across dates table.

vaibhavd — Fri, 27 Dec 2019 06:46:31 GMT

Please help me on this.

Re: Count values generated by measure across dates table.

Mariusz — Fri, 27 Dec 2019 10:03:43 GMT

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

Re: Count values generated by measure across dates table.

az38 — Fri, 27 Dec 2019 11:45:00 GMT

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