how to convert qlikview expression in power BI

[sakshikaul]

qlikview Expression 

=IF($(selectYear)=$(selectYear) ,

sum({<Eco_year={$(selectyear2)}>}([ChglWt(KG)]/1000)+Tues+(CBM/25)))

Please help me in converting above qlik expression in power BI 

[camargos88]

@sakshikaul ,

It would be easier if you give an example of what you need to do.

[sakshikaul]

I want to sum ChglWt(KG)/1000  on the basis of (Filter) where Mode group 3 = AIRIMPORT . How to write a measure for this on front end ?

Qlikview Expression -((SUM(IF(Mode_group_3 = 'AirImport',[ChglWt(KG)],0)))/1000)

[Anonymous]

@sakshikaul you need to create 2 measure 

measure 2 = 
CALCULATE (
    DIVIDE ( SUM (ChglWt(KG), 1000 ),
    Mode group 3 = "AIRIMPORT"
)

Try this ,It will work for you .

Give me kudos 

Thank you 

[sakshikaul]

Hi, 

I shhould get values as follows 

whereas I am getting values as 

Please help

[Anonymous]

@sakshikaul  then write this then 

1. Measure 1 = Calculate(sum(SUM (ChglWt(KG)), Mode group 3 = "AIRIMPORT")

above measure will give sum of ChglWt(KG)) .where mode group 3 value is aimimport .

or 

you can sent me snapshot of your data for better understanding as your requirement is not clear .

[sakshikaul]