Forum Discussion
Filter Results by Multiple Tables
Thank you for your follow up and clarification of the issue. I tried to produce your required output in a single formula, but it didn't work, but when I split the measure in two, first producing the measure like below, and then in a separate measure, sumxing it over 'City, State' dimension, it produced your required output. I am not sure why it couldn't be done in one measure, but it must be due to the intricate filter contect related matter as you said.
In the second measure where it sumxed over the 'City, State' dimension, it is simply like below.
Sumx_City_State_BothRtlrsECOnly = sumx(City_State,[BothRtlrsECOnly])I also encountered similar issues, where it didn't produce the intended output in one long measure, but when I split it out in two measures, it produced the required output.
I attach the pbix file below.
Super UserThank you for your follow up and clarification of the issue. I tried to produce your required output in a single formula, but it didn't work, but when I split the measure in two, first producing the measure like below, and then in a separate measure, sumxing it over 'City, State' dimension, it produced your required output. I am not sure why it couldn't be done in one measure, but it must be due to the intricate filter contect related matter as you said.
In the second measure where it sumxed over the 'City, State' dimension, it is simply like below.
Sumx_City_State_BothRtlrsECOnly = sumx(City_State,[BothRtlrsECOnly])I also encountered similar issues, where it didn't produce the intended output in one long measure, but when I split it out in two measures, it produced the required output.
I attach the pbix file below.
DataNinja777 This worked great, thank you very much for your help.
Also, I did not consider using variables within the first measure as an alternative to the excess measures within the file. Very good idea, keeps everything cleaner.
