Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Clarification in table relationship

  Lets consider i have a model like this. Relationship between sales and state is both   I want to see quota by state in a table     Quota of state XXXX will not be displayed in tab...
General Comment
Need Help
Tips and Tricks
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Dinesh,

     

    There could be two methods.

    Method one:

    1. Create a new inactive relationship;

    2. Create a measure.

    Measure =
CALCULATE (
    SUM ( Seller[Quota] ),
    USERELATIONSHIP ( Seller[State ID], State[ID] )
)

    Clarification_in_table_relationship1

    Method two:

    Create a measure.

    Measure 2 =
IF (
    MIN ( State[ID] ) IN VALUES ( Sales[State] ),
    BLANK (),
    CALCULATE (
        SUM ( Seller[Quota] ),
        FILTER ( Seller, Seller[State ID] = MIN ( State[ID] ) )
    )
)

    Clarification_in_table_relationship2

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Dinesh,

 

There could be two methods.

Method one:

1. Create a new inactive relationship;

2. Create a measure.

Measure =
CALCULATE (
    SUM ( Seller[Quota] ),
    USERELATIONSHIP ( Seller[State ID], State[ID] )
)

Clarification_in_table_relationship1

Method two:

Create a measure.

Measure 2 =
IF (
    MIN ( State[ID] ) IN VALUES ( Sales[State] ),
    BLANK (),
    CALCULATE (
        SUM ( Seller[Quota] ),
        FILTER ( Seller, Seller[State ID] = MIN ( State[ID] ) )
    )
)

Clarification_in_table_relationship2

 

Best Regards,

Dale

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Dale,

This solution worked.

 

Thanks,

Dinesh J.