Calculate value based conditions other columns

[Anonymous]

Hello,

I need some help about multiple condition and linked at two slicers. 

I have two slicers: 1) exchange currency and 2) apply special formula:

1) (EUR) and (USD)

2) are simple slicer to apply formulas sl1 (default)-sl2 (minus a fixed value)-sl3 (minus other fixed value)

Fact table like as:

Date	Tag	values	conv_applied?	pos_applied?	exchange_rate
2020-03-01	tagA	45	yes	not	1.5
2020-03-01	tagB	51	not	not	1.5
2020-03-01	tagC	80	not	not	1.5
2020-03-01	tagD	70	yes	yes	1.5

Si , I create the slicers and I made a new calculate column to convert values to USD, when conv_applied col met the condition.

dolarConv = IF(
                FactsTable[conv_applied]=TRUE();
                DIVIDE(FactsTable[values]*FactsTable[exchange_rate];(1*FactsTable[const]));
                FactsTable[values]
)

second slicer will be apply in another combination. But I cannot to link this with the slicer, when I click USD, the plot don't show me the value. 

Thanks for your help, here my template. 

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Greg_Deckler]

Didn't quite follow that, but if you are trying to update a column in a table based on a slicer, you can't do that.

[Anonymous · Accepted solution]

Hi @Greg_Deckler ,yes I understand you are right. I see other option, create different measure to calculate conversion and shows in the table? 

Because, I tried with it, and works, but I cannot to link the evaluation if conversion is applied or not by Boolean info on the table. I attached another example. (Obviously my table is only an example, I want to see only converted or not value per tag selected.).

Anybody could me give a suggestion? 

Thanks

Mr

[Anonymous]

Hello,

I solved myself my dilemma. 

After to create new two columns , I'd apply a special measure to interact both slicers per each rows, by condition pre-calculated.

I'll open a new thread about value format. Anyway, I'd found some suggestion in the forum.

thanks.