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.
Hi there,
I got a dimension table of a personal record (let's called individual), and a qualification information table. I got two dimension tables: Authorisation and Individual qualification. The authorization table contains information about the license an individual holds, validation date of the license (i.e. start and expiry dates). The individual qualification contains information about the qualification the individual holds. An individual can have one or more licenses and qualifications. So, my data model looks like as follow:
I wanted to calculate the no of individuals (with valid licenses). My measure looks as follow:
Solved! Go to Solution.
Hi @Dunner2020
Modify the cross-filter direction from Single to Both for the relationship between Individual table and IndividualQualification table. This will work.
And in the table visual, drag the QualificationDescription column from Qualification table instead of individualqualification table, and use TODAY() to replace NOW() function in your measure. This will improve the speed for calculation.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Dunner2020
Modify the cross-filter direction from Single to Both for the relationship between Individual table and IndividualQualification table. This will work.
And in the table visual, drag the QualificationDescription column from Qualification table instead of individualqualification table, and use TODAY() to replace NOW() function in your measure. This will improve the speed for calculation.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@Dunner2020 , I do not see the join between qualifications and Authorisation(Dimensions are fine. They do not join) , so that means cross join behavior. You need have join of handle that in meausre
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |