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[...
DAX
Help me
Measures
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