Forum Discussion

DanCasSan's avatar
DanCasSan
Helper V
5 years ago
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...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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 

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

DanCasSan  When you use a CALCULATE it modifies the filter context of your report and gives the same value. You can either use a visual level filter or try a SUMX instead. The SUMX will keep the current filter context of your table and add the additional filter context you apply to it.

 

 

 CFO BCP = SUMX( FILTER(TBL_Patrimonio, ,TBL_Patrimonio[DESC_CONCEPTO] IN {"CROSLAND CFO","FAMILY OFFICE BCP"} ), TBL_Patrimonio[MTO_CONCEPTO])