The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I've brought a table into Power BI and expanded it (in order to create an additional row for every day between two different date fields. I needed to do this so I could count how many Members were part of a healtcare plan for any portion of the year). I then went ahead and created my Date/Calendar table and created the relationships. Everything is working properly:
However, I'm now trying to create an additional measure on a table visual and I'm struggling with this. Here is my current table:
I'd like to create a New Measure called "Employee"...where it will count distinct Member IDs. Currently, the Members column in the table visual above is counting distinct values of the 'NovaDailyEligibilityExtract'[Member ID] field. The New Measure I'd like to create should count distinct values of the 'NovaDailyEligibilityExtract'[Member ID] field...but only if my 'NovaDailyEligibilityExtract'[Relationship] field = Employee.
What is the formula to create this New Measure?
Solved! Go to Solution.
Can you please try something like
X=
Can you please try something like
X=
That worked perfectly. Filter is such a powerful and useful tool.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
136 | |
106 | |
102 | |
73 | |
59 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
86 |