Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |