Forum Discussion
Help with Dax to create a filtered selection based on two grouped columns
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
6 Replies
- aj1973
Community Champion
Hi Anonymous
Somehow Page 1 is bugging. I opened a new page and it is working fine
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
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).
