Forum Discussion

pawelj795's avatar
pawelj795
Post 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

After a quick look at your model, it seems that your relationship isn't correct. 


You are linking 'IndexList'[ItemID] -> 'IndexList'[ItemID] instead of 'IndexList'[Item Number] -> 'Values'[ITEMID]

 

 

  • pawelj795's avatar
    pawelj795
    Post Prodigy
    6 years ago

    Thanks Anonymous  for noticing!

    It's a dummy mistake, but in my main model that's not the issue, it's something else.

    After fixing relationship, it still shows some blank grouping.

     

    • 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
        Post 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?

    • pawelj795's avatar
      pawelj795
      Post Prodigy
      6 years ago

      Maybe my logic was wrong?

      That I can't group index by difference between Max and Min value.