The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
Hopefully I have put this in the right place.
I am trying to make a cluster chart with the following information: Y axis # number users, X axis location.
I've tried the following to get a filtered measure on the last login date that I found online but I'm just getting the total count.. The date filter isn't being applied.
Any ideas?
Solved! Go to Solution.
HI @FlyingBlind,
You can try to use the following measure formula if it stable for your requirement: (get the last date based on table records as condition to calculate the percent of total)
COUNT_Logins_After_May =
VAR _lastdate =
CALCULATE (
MAX ( Users[Last Login] ),
FILTER ( ALLSELECTED ( Users ), [Last Login] <> BLANK () )
)
RETURN
DIVIDE (
CALCULATE ( [COUNT_Logins], Users[Last Login] >= _lastdate ),
[COUNT_Logins]
)
Regards,
Xiaoxin Sheng
HI @FlyingBlind,
You can try to use the following measure formula if it stable for your requirement: (get the last date based on table records as condition to calculate the percent of total)
COUNT_Logins_After_May =
VAR _lastdate =
CALCULATE (
MAX ( Users[Last Login] ),
FILTER ( ALLSELECTED ( Users ), [Last Login] <> BLANK () )
)
RETURN
DIVIDE (
CALCULATE ( [COUNT_Logins], Users[Last Login] >= _lastdate ),
[COUNT_Logins]
)
Regards,
Xiaoxin Sheng
User | Count |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
22 | |
14 | |
14 | |
9 | |
7 |