Forum Discussion

jrwjr_eng's avatar
jrwjr_eng
Regular Visitor
9 years ago
Solved

DAX help with a conditional classifer

I may be making this more difficult than needed....   I have a data table that I would like to filter with complex conditioonsn and then classifiy into a measure for pivot reporting.   See the be...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    jrwjr_eng

     

    I still can't understand your logic. In your Dim T_Bunch table, your RunCode and Bunch is 1-to-1 relationship.

     

    What do you mean "RunCode = 104" AND "Bunch Code=5"?

     

    If you are counting the invoices which matches your condition, can you explain why you get those results in the bottom table?

     

    Regards

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

jrwjr_eng

 

I still can't understand your logic. In your Dim T_Bunch table, your RunCode and Bunch is 1-to-1 relationship.

 

What do you mean "RunCode = 104" AND "Bunch Code=5"?

 

If you are counting the invoices which matches your condition, can you explain why you get those results in the bottom table?

 

Regards

jrwjr_eng's avatar
jrwjr_eng
Regular Visitor
9 years ago

Yes, Invoice counts is the goal.

 

Invoice Units = CALCULATE( COUNTX( FILTER('RunningTbl', 'RunningTbl'[bc]="104"), 'RunningTbl'[invoice]))

For unit counts... I need to aggregate the data table by a grouping (for example of Invoice 123 = 104 AND TG, then grouping 5 and classfied by the INSID color of the TG = Blue)

 

I went to look for SQL examples and found a DAX Dynamic Segmentation that is an example of a numeric classifier.  If I can port this over from a numeric range to a alpha index in a parameter table, I may have a way.

 

http://www.daxpatterns.com/dynamic-segmentation/

https://powerpivotpro.com/2014/11/new-twist-for-dynamic-segmentation-variable-grain-range-selection

 

I know I am making this harder than it needs to be.

 

In plain english, I want to test Invoices and if they known combnations of RunCodes to classify them as Reflections or Mirrors.  Then count\total classification as the Insid color for the RunCodes in t_group 5.