Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 ProducerCons...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Here you go

 

Obviously you didn't read my previous reply

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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).