Forum Discussion

vaibhavd's avatar
vaibhavd
Frequent Visitor
6 years ago

Count values generated by measure across dates table.

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 ?

 

DAX
Help me
Measures

3 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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's avatar
      az38
      Icon for Community Champion rankCommunity Champion
      6 years ago

      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