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 file.
https://drive.google.com/file/d/1-0FFmgcW3ILsubHVMJfe-8z7K_V5bys3/view?usp=sharing


Important thing, the grouping must be created in a column, because I want to filter my data by it.

Thanks In advance for any help!

Data Protection
Need Help
Tips and Tricks

5 Replies

  • 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.