Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Just one condition that I have is that we can't use NC entries in any of the filters in DAX.
That makes it impossible to implement a solution.
Hey @lbendlin,
Thanks for your response. But I just want to get the count of such parent companies for which all sub companies are compliant for all parameters. And just one more point, we can't say whether any company has entries for all the parameters in the fact table. So, we need to compare the number of entries for each child in the fact with the distinctcount of parameters in dimparameters. I am doing something similar in my file but somehow it is not working. Could you have a look at that?
Waiiting for your response
Regards
I don't understand what you are trying to achieve. Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Hey @lbendlin ,
Sorry for the confusion, based on the sample data, the expected outcome is 1. I just want to create a card with number of parents compliant.
Just one condition that I have is that we can't use NC entries in any of the filters in DAX.
Just one condition that I have is that we can't use NC entries in any of the filters in DAX.
That makes it impossible to implement a solution.
Thats what it looks like. I think I need to create a calculated table first after filtering the NC entries and add a calculated column there which can do a count of parameters for each company individually. Then based on that column I can do parent level calculation as well in the measure
Like this?
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
28 | |
22 |