Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
55 | |
46 | |
18 | |
16 | |
15 |
User | Count |
---|---|
115 | |
42 | |
41 | |
27 | |
22 |