Sum of measures does not work - segment/filter issue

[Anonymous]

Hi ,

I have 2 measures :

CO2_tlseParis = Switch ( True(),

SELECTEDVALUE(mode_transport[transport_commute],"") = "avion",SELECTEDVALUE(tlseParis[distance],0) * 0.0826 * 2 + SELECTEDVALUE('hubBureau'[distance],0)* 0,

SELECTEDVALUE(mode_transport[transport_commute],"") = "voiture" ,SELECTEDVALUE(tlseParis[distance],0) * 0.0130 * 2 + SELECTEDVALUE('hubBureau'[distance],0) * 0,

SELECTEDVALUE(mode_transport[transport_distance],0) = 0,0

)

CO2_hubBureau = Switch ( True(),

SELECTEDVALUE(mode_transport[transport_commute],"") = "taxi_uber", SELECTEDVALUE('hubBureau'[distance],0) * 0.055 * 2 * 5 ,

SELECTEDVALUE(mode_transport[transport_commute],"") = "metro" ,SELECTEDVALUE('hubBureau'[distance],0) * 0.003 * 2 * 5

)

With the current filters, I get :

CO2_tlseParis = 26

CO2_hubBureau = 35.75

When I sum both measure in another one I get 0.

I guess my issue comes from the interaction between filters. Indeed, each measure depends on 2 filters each, with one common dataset and 2  with 2 different ones.

Any idea how I could deal with this?

[amitchandak]

@Anonymous , seems strange.Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Please note that the issue comes from the measure at the bottom of the page

[dax · Accepted solution]

Hi @Anonymous , 

I think this might be cuased by the interactions of visual. In your scenario, I find that there is no relationship between each other, so I think you could create another tables for slicer instead of use slicer from same table. You could  refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

https://drive.google.com/drive/folders/1FPENbL7kz25Rasav1BQ9ANwa9PNsrgro?usp=sharing