Forum Discussion

nice_boy's avatar
nice_boy
Regular Visitor
9 years ago

DAX problem calculating value

 Hello,

I want to create measure in the table "TAB_1", which sums up tle values "VALUES" from the table "TAB_2" only then if in the table "TAB_2" appears "cont_id" bigger than 0. I enclose screencast of my model. In my opinion, I have to activate inactive relationships. These relationships must be inactive in the model. I have now created something like this:

Values = CALCULATE(sum(TAB_2[VALUES]); 
USERELATIONSHIP(TAB_1[TAB1_id];TAB_2[TAB2_id]); TAB_2[cont_id]>0; 
USERELATIONSHIP(TAB_1[date];TAB_DATE[date]))

Unfortunately, this measure sums up everything from "VALUES" and it doesn't work on date filters.

 

 

 

 

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    To me it looks like you are overcompliating the measure itself.  You already have the table relationships so just try this simple measure:

    Values = CALCULATE(
	sum(TAB_2[VALUES]),
	TAB_2[cont_id] > 0
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Change the link between the date table and Tab_1 to be Both directions.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi nice_boy,

     

    Based on my test, the above measure you provided works fine to generate the sum value. Below is the result in my test. I used a card visual to display the measure value.

     

    In your scenario, what visualization did you use? Please show us the current output which does not meet your requirement.

     

    Regards,
    Yuliana Gu