Forum Discussion
Dynamic Column based on Slicer input
Hi there, See the below pictures for context. I am currently using static columns to determine error in data. In Picture 1, you will see that I have 5%,10%, and 20% error columns which are calcu...
Hi Anonymous ,
calculated columns cannot be dynamic based on a slicer. however, you can realize this using calculated measures
In a calculated measure, you can use SUMX to add up the 1 and 0 that you calculate in each row. I recently made a blog post on using SUMX inside a calculated measure, you can find it here:
https://finance-bi.com/power-bi-totals-incorrect/
It's a different context than yours, but it might help you.
Let me know if you need any additional help. In that case, please share your Power BI file using One Drive, Google Drive or similar tool and I can take a look.
Regards
LC
Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com