Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
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
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
Please help me on this.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |