Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |