Forum Discussion

KristyP's avatar
KristyP
Icon for Helper I rankHelper I
3 years ago
Solved

DAX Calucation

Hi,   I have two related tables. I am trying to find a value in one table based on a range ( min & max) and a category from the first table. The value I require is in the second table, seperate col...
  • KristyP's avatar
    KristyP
    3 years ago

    Sure, I can do this tomorrow.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

KristyP 
This is supposed to be a calculated column in Table1 not a measure.

KristyP's avatar
KristyP
Icon for Helper I rankHelper I
3 years ago

I haved used this calculation. But there are some issues with it not always picking up the correct value. This issue does not seem relate to any one particular Product Goup or band. Any ideas what could be casuing this issue?

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

    KristyP 
    Can you provide a sample file that clarifies these inconsistencies?

     

    • KristyP's avatar
      KristyP
      Icon for Helper I rankHelper I
      3 years ago

      I need to protect the information for work purposes. But I will complete a sample file tomorrow and send it through.

      • KristyP's avatar
        KristyP
        Icon for Helper I rankHelper I
        3 years ago

        I have done this very quickly, please see below

        I made sure there was a relationship between the two tables