Forum Discussion

pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
6 years ago

Grouping based on Max_Min Difference

Hi everyone, I want to group my index list based on the difference between their Max and Min Value. I can't really figure out why my idea won't work, everything seems fine. I share below my sample...
Data Protection
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I don't see anything that's wrong, I think the measures are working correctly.

But in the dataset you have some infinity values, and the max for bad = 1000000. So ofcourse infinity - Min= infinity   so it's normal that there are some blank values. 

 

pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
6 years ago

Anonymous 

Thanks again 😉

I finally figured it out.

I should have to add one more column from my model.

Because in the table Value there is also a column with Dates.
And this dates was filtered by page filter.

So I suppose that this filter doesn't work on measures with function MAX or MIN?

If am I correct, how to add this filtering to my measures?