Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"})
But, when I put my matrix with the data it is repeating the same values for each description.
What should I modify to achieve what I am putting in the formula is fulfilled? The data is in a single table.
Thank you!
Reggards.
DC
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi,
Does this work?
CFO BCP = CALCULATE(SUM(TBL_Patrimonio[MTO_CONCEPTO]),filter(TBL_Patrimonio,TBL_Patrimonio[DESC_CONCEPTO] ="CROSLAND CFO"&&TBL_Patrimonio[DESC_CONCEPTO] ="FAMILY OFFICE BCP"))
Hope this helps.
@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])
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |