Forum Discussion

Saxon202202's avatar
Saxon202202
Icon for Helper III rankHelper III
3 years ago

Min and max based in-between two tables

Hi, I have two tables are Data and Report. In data table contain the following columns are Item, country code, sale qty. In report table contain the following columns are item and project co...
Need Help
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
3 years ago

Saxon202202  does this measure work when you drop it on DATA

measure= maxx(relatetable('fact'), 'fact'[countryCode]))
  • Saxon202202's avatar
    Saxon202202
    Icon for Helper III rankHelper III
    3 years ago

    smpa01 , Thanks for your reply. No, it doesn't work.

    • smpa01's avatar
      smpa01
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Many to many is not best practice but I will leave arguing for that portion and simply going to assume that you have a business case.

       

      I refrain from working with many to many but I can see that it works with an indirect relationship without a USERELATIONSHIP callback

       

       

       

       

      • Saxon10's avatar
        Saxon10
        Icon for Post Prodigy rankPost Prodigy
        3 years ago

        smpa01, Thanks for your reply. It means I need to remove the relationship in between two tables?

        Is that possible to create a unique count for country code, TOPN in order to filter the result in report table? I tried couple of function but it doesn't work for me.