topic Re: Unable to get the count of parents whose child are all compliant using DAX in DAX Commands and Tips

Unable to get the count of parents whose child are all compliant using DAX

Aksh_12345 — Thu, 02 May 2024 14:58:53 GMT

I am stuck in a problem for last two days. Actually I have a table in which I have few companies and their parent companies. Apart from this I have another table in which I have few parameters. So these are two dimensional tables and I have a fact table in which I have the information of each company and their complaints status for the parameters. Now I had two requirements,

1. I wanted to have The count of the company's which are Compliant for all the available parameters and I have created a measure for that Which is working completely fine.

2. I want to see the count of parent companies For which all the childs are complaint against every parameter that is available in the dim table. This measure is somehow not working properly.

I am attaching a Power BI file for your reference. Please help me.

Link- Download

Let me know if there is any confusion

PS-- this was not a relationship problem, because I had the relationship created between the dim and fact tables but removed it for some testing and trying out few logics.

Re: Unable to get the count of parents whose child are all compliant using DAX

ThxAlot — Thu, 02 May 2024 19:25:33 GMT

Re: Unable to get the count of parents whose child are all compliant using DAX

Aksh_12345 — Fri, 03 May 2024 12:25:21 GMT

Hi ThxAlot ,

Thanks a lot for your response. I can't use NC in my condition, ecause in actual data, I cant use NC entries as a criteria because there are some scenarios where we have C and NC both records present for same company, same parameter and same period and then we are considering it as C for that comapny for that parameter for that period. I hope I haven't made it confusing 😅. Thanks in advance