Forum Discussion
Helper IIISpecific value to be added from a value derived from a conditional value
Super Userstill can't find any relationship between TABLE A and B.could you pls explain why FLP1 will minus -573? I can't find any related columns in both tables.
Helper IIIHi ryan_mayu,
I created index column in both Table A and Table B to be able to make one to one relationship happen between the two. Beween the Table A and Table C (which i created to be able to dynamically filter based on DISTINCT_CODE column between the other tables as well) there is an inactive relationship for DISTINCT_CODE column from Table C and BAND_COL from Table A. Something like as i am trying to show in the image below. I may be doing something wrong.
It can be FLP1 will plus -573 (From Table B). The last DAX above called Measure is calculating FLP1 + (-573) properly, the only thing it is not doing is that it doesn't give me the aggregated values calculated for "ML (P1)", "PTML (P1)”.
Me being not so knowledgeable about PBI i definitely am doing something wrong somewhere.
Much appreciated!
- ryan_mayu
the index are not matching for FLP1 and -573. One is index 4 and the other is 6. Still don't know the logic of calculation. If FLP1 will always add the subtotal in table B, you can try
=if (selectedvalue(DISTINCT_CODE) ="FL(P1)", XXXX)