Forum Discussion
Solved
Repeated values in array
Hello partners! I am performing the following calculation: CFO BCP = CALCULATE(SUM(TBL_Patrimonio[MTO_CONCEPTO]),TBL_Patrimonio[DESC_CONCEPTO] IN {"CROSLAND CFO","FAMILY OFFICE BCP"}) B...
Since you are filtering the same column in your measure that is used in your visual, the measure filters are overwriting the one from the visual. If you want to only show results for those two values, you can modify your measure like this.
CFO BCP = CALCULATE(SUM(TBL_Patrimonio[MTO_CONCEPTO]),KEEPFILTERS(TBL_Patrimonio[DESC_CONCEPTO] IN {"CROSLAND CFO","FAMILY OFFICE BCP"}))If that is not what you are looking for, please show your desired output.
Regards,
Pat
Since you are filtering the same column in your measure that is used in your visual, the measure filters are overwriting the one from the visual. If you want to only show results for those two values, you can modify your measure like this.
CFO BCP = CALCULATE(SUM(TBL_Patrimonio[MTO_CONCEPTO]),KEEPFILTERS(TBL_Patrimonio[DESC_CONCEPTO] IN {"CROSLAND CFO","FAMILY OFFICE BCP"}))
If that is not what you are looking for, please show your desired output.
Regards,
Pat