Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 below example. DimINS may be extra\unneeded. I have defined the measures I am looking to pivot with the report example at the bottom.
Thanks for helping in advance. It all seams to foggy when it really should be simple dynamic conditions.
RunningTbl | dimT_Bunch | dimINS | |||||||||
Invoice | RunCode | Insid | Runcode | Bunch | Insid | Name | |||||
123 | 104 | Red | TT | 5 | Red | Red Inidustry | |||||
123 | TT | Blue | TF | 5 | Blue | Blue Induistry | |||||
123 | TG | Blue | 104 | 3 | |||||||
124 | 104 | Blue | 125 | 3 | |||||||
124 | 101 | Blue | 101 | 3 | |||||||
124 | TT | Blue | |||||||||
125 | 104 | Red | |||||||||
125 | 127 | Red | |||||||||
125 | TF | Blue | |||||||||
126 | 104 | Red | |||||||||
127 | 104 | Blue | |||||||||
Reflection = 'Count num of Runcode = "104" and Classify invoice by red or blue bases on Bunch code = "5" | |||||||||||
Mirrors = Count num of Runcode = "104" where invoice not classifed by Bunch Code ="5" use Insid | |||||||||||
Reflections | Mirrors | Bunch 5 | |||||||||
Red | 0 | 1 | 0 | ||||||||
Blue | 4 | 0 | 3 |
Solved! Go to Solution.
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
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
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |