Forum Discussion
Solved
ANALYSIS TABLE/COUNTX FUNCTION
I am trying to create a small analysis table which gives a breakdown of the number of items which fall within certain lead times.. In excel, this would be a simple matter of using COUNTIF/COUNTIFS bu...
I have got this to work, but it gives me totals based on all of the data in the table. I have the rest of the report filtered by customer. How do I make this filter apply to the parameter table?
Thank you.
Regards.
Colin
Zubair_Muhammad
Community Champion
Community Champion- Zubair_Muhammad
Hi colsand
The solution to this is to go other way round
Instead of Pulling data from LT Data into Parameter Table..... Pull the Cluster name from Parameter Table into LT Data
Create a calculated Column in LT Data as follows
Cluster LT = CALCULATE ( VALUES ( Parameter_Table[Cluster LT (Days)] ), FILTER ( Parameter_Table, 'LT Data'[Lead Time] >= Parameter_Table[Start] && 'LT Data'[Lead Time] <= Parameter_Table[End] ) )- Zubair_Muhammad