Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
vaibhavd
Frequent Visitor

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_
)

 

Achieved.png

 

Now I want to have following output.

output expected.png

 

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

 

3 REPLIES 3
Mariusz
Community Champion
Community Champion

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
Community Champion
Community Champion

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

7645.png

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

LinkedIn


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
vaibhavd
Frequent Visitor

Please help me on this.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.