Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello All,
I have following tables and their relationship in a tabular model. In report, i have two slicers in report.
Slicer1 is on [D_Date].[DateYear]
Slicer2 is on [D_Member].[ProviderType]
i have to show year wise([D_Date].[DateYear]) distinct Member count using [D_AllMembers].[MemberID] but it is showing same count for each year. Can someone please guide me on how to get the desired result.
Many Thanks
Tables=> | D_AllMembers | D_Member | F_Members | D_Date | |||
Fields=> | MemberID | MemberID | MemberID | DateKey | |||
MemberKey | MemberKey | DateYear | |||||
ProviderType | DateKey |
F_Members(MemberKey)=>Many to One <=D_Member(MemberKey) |
F_Members(MemberID)=>Many to One <=D_AllMembers(MemberID) |
F_Members(DateKey)=>Many to One <=D_Date(DateKey) |
Solved! Go to Solution.
Hi @Ansari010 ,
You can create a measure as below to get it:
Measure =
VAR _seldkeys =
ALLSELECTED ( 'D_Date'[DateKey] )
VAR _selmkeys =
ALLSELECTED ( 'D_Member'[MemberKey] )
VAR _fmids =
CALCULATETABLE (
VALUES ( 'F_Members'[MemberID] ),
FILTER (
'F_Members',
'F_Members'[DateKey]
IN _seldkeys
&& 'F_Members'[MemberKey] IN _selmkeys
)
)
RETURN
CALCULATE (
DISTINCTCOUNT ( 'D_AllMembers'[MemberID] ),
FILTER ( 'D_AllMembers', 'D_AllMembers' IN _fmids )
)
Best Regards
Hi @Ansari010 ,
You can create a measure as below to get it:
Measure =
VAR _seldkeys =
ALLSELECTED ( 'D_Date'[DateKey] )
VAR _selmkeys =
ALLSELECTED ( 'D_Member'[MemberKey] )
VAR _fmids =
CALCULATETABLE (
VALUES ( 'F_Members'[MemberID] ),
FILTER (
'F_Members',
'F_Members'[DateKey]
IN _seldkeys
&& 'F_Members'[MemberKey] IN _selmkeys
)
)
RETURN
CALCULATE (
DISTINCTCOUNT ( 'D_AllMembers'[MemberID] ),
FILTER ( 'D_AllMembers', 'D_AllMembers' IN _fmids )
)
Best Regards
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |