CALCULATE (MAX (FILTER only works on dataset with the most row... Help

[Hann_Sen]

Hello Mentors,

HRImax = CALCULATE(MAX('HRI'[VF_V]),FILTER(ALL('HRI'),'HRI'[Probe]=MAX('HRI'[Probe])))

The above Dax script only works for data sets with the most row. How can I improve it?

If you filter [DataLink_HRI] = HRI_2485 -> it works ... 39 rows

If you filter [DataLink_HRI] = HRI_2878 -> doesn't work ... 16 rows

Probe	DataLink_HRI	If_A	VF_V	HRImax
1	HRI_2485	0.002	2.54016	2.94645
1	HRI_2485	0.005	2.57442	2.94645
1	HRI_2485	0.01	2.6001	2.94645
1	HRI_2485	0.02	2.62642	2.94645
1	HRI_2485	0.03	2.64242	2.94645
1	HRI_2485	0.05	2.66393	2.94645
1	HRI_2485	0.08	2.68587	2.94645
1	HRI_2485	0.1	2.6975	2.94645
1	HRI_2485	0.2	2.74054	2.94645
1	HRI_2485	0.35	2.78976	2.94645
1	HRI_2485	0.5	2.83092	2.94645
1	HRI_2485	0.7	2.88005	2.94645
1	HRI_2485	1	2.94645	2.94645
2	HRI_2485	0.002	2.5399	2.9477
2	HRI_2485	0.005	2.5746	2.9477
2	HRI_2485	0.01	2.60016	2.9477
2	HRI_2485	0.02	2.62616	2.9477
2	HRI_2485	0.03	2.64236	2.9477
2	HRI_2485	0.05	2.66384	2.9477
2	HRI_2485	0.08	2.68579	2.9477
2	HRI_2485	0.1	2.69758	2.9477
2	HRI_2485	0.2	2.74103	2.9477
2	HRI_2485	0.35	2.78999	2.9477
2	HRI_2485	0.5	2.83123	2.9477
2	HRI_2485	0.7	2.8806	2.9477
2	HRI_2485	1	2.9477	2.9477
3	HRI_2485	0.002	2.53961	2.94726
3	HRI_2485	0.005	2.57401	2.94726
3	HRI_2485	0.01	2.59999	2.94726
3	HRI_2485	0.02	2.62604	2.94726
3	HRI_2485	0.03	2.64219	2.94726
3	HRI_2485	0.05	2.66376	2.94726
3	HRI_2485	0.08	2.68596	2.94726
3	HRI_2485	0.1	2.69732	2.94726
3	HRI_2485	0.2	2.74074	2.94726
3	HRI_2485	0.35	2.79002	2.94726
3	HRI_2485	0.5	2.83089	2.94726
3	HRI_2485	0.7	2.88051	2.94726
3	HRI_2485	1	2.94726	2.94726
1	HRI_2878	0.002	1.6141	2.94645
1	HRI_2878	0.005	1.64488	2.94645
1	HRI_2878	0.01	1.66917	2.94645
1	HRI_2878	0.02	1.6961	2.94645
1	HRI_2878	0.03	1.71433	2.94645
1	HRI_2878	0.05	1.74057	2.94645
1	HRI_2878	0.08	1.771	2.94645
1	HRI_2878	0.1	1.78848	2.94645
2	HRI_2878	0.002	1.61376	2.9477
2	HRI_2878	0.005	1.64465	2.9477
2	HRI_2878	0.01	1.66888	2.9477
2	HRI_2878	0.02	1.69604	2.9477
2	HRI_2878	0.03	1.7141	2.9477
2	HRI_2878	0.05	1.74059	2.9477
2	HRI_2878	0.08	1.77077	2.9477
2	HRI_2878	0.1	1.78831	2.9477

[v-tangjie-msft · Accepted solution]

Hi @Hann_Sen ,

We can create a measure.

HRImax = CALCULATE(MAX('HRI'[VF_V]),FILTER(ALLEXCEPT('HRI','HRI'[Probe],'HRI'[DataLink_HRI]),'HRI'[VF_V]))

If this does not match your expected results, please provide the output of the sample data you are expecting. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.