Help with Dax to create a filtered selection based on two grouped columns

[Anonymous]

I have this report with the following rules:

Check PBIX: 

https://drive.google.com/file/d/1C1xb-CGPMWVs1qyS3e9HtPr2IWgTM_iW/view?usp=sharing

The table  "report ProducerConsumerTaskCodes"  is a subset of "report ConsumerTaskCodes".

Card "Total codes used by firm for all clients"  is from table "report ProducerConsumerTaskCodes"  

Card  "Total number of codes used by all firms"  is from table "report ConsumerTaskCodes".

Card "Total codes used by firm for all clients"  is not expected to be equal to the sum of rows in "codes used by firm" because only unique codes aggregated.  

Also, 

"Total count of codes used by all firms" is not expected to be equal to the sum of rows in "Codes used by firm" because only distinct codes (Clientname+taskcode) are to be aggregated.  Currently it is based on just taskcode - wrong.      

The problem:

1.  I need to extract distinct/count of  Clientname+taskcode (not just based on taskcode as currently implemented) for both colunms. 

2. Only codes with sum of "report ConsumerTaskCodes" - confidencescore for selected Clientname+taskcode  > 50 are to be considered in the reported (filtered).

3. Note:  It does seem like I have an issue with relationshiop.  Please see tab Page 1.  

PBIX:  https://drive.google.com/file/d/1C1xb-CGPMWVs1qyS3e9HtPr2IWgTM_iW/view?usp=sharing

[Anonymous]

Hi @Anonymous ,

Has the problem be solved?

Best Regards,

Jay

[Anonymous]

@aj1973 

Pull into the table any non-additive column from "report ProducerConsumerTaskCodes"  table e.g taskcode, or concumerId.  It breaks.  Obviously a relationship issue.  This is just ine of the 3 issues mentiooned.  Resolving this should throw reveal the issue with first 2 problems I mentioned.  

[aj1973]

Here you go

Obviously you didn't read my previous reply

[Anonymous]

@aj1973 

May I have yoiur PBIX to see what tables the columns are pulled from?  

You will observe that the field confidencescore is repeated indciating a probale relationship problem.  To confirm this, in Values, you may set Confidencescore to "Don't summerize". 

My altimate goal is to :

1.  I need to extract distinct/count of  Clientname+taskcode (not just based on taskcode as currently implemented) for both colunms. 

2. Only codes with sum of "report ConsumerTaskCodes" - confidencescore for selected Clientname+taskcode  > 50 are to be considered in the reported (filtered).

[aj1973]

https://drive.google.com/file/d/1UR0WsbufPMKXzp67JnRWBSKsAgNuRUi7/view?usp=sharing

Your requests are not clear.

[aj1973]

Hi @Anonymous 

Somehow Page 1 is bugging. I opened a new page and it is working fine