Sorting out Row Context Calculation filtered by Slicer

[u92690]

I'll try to approach the issue theoretically. 

I already know that calculated columns cannot be changed by slicers, so I'm struggling to find the solution. I have a database of loans in which i have several calculated columns such as average life or period of lack. These two columns depend on the variables in the row context, but also on the date on which i want to measure them (i.e., i can measure the average life remaining today, but i could check it in another dates). 

The thing is that I manage to check all the variables for one date (i make the formulas so that i can get them for the current date). I guess some of you would suggest me to create measure instead of calculated colums..the point is that the way it is calculated the "average life" or period of lack depend on the type of loan, so I'm not able to create a generic code for the measure. 

Any help to solve this?? Thanks!

@amitchandak @PaulDBrown @johnt75

[v-xiaotang]

Hi @u92690 

If you can provide more details, it will help us find a solution faster.

Usually information below is needed, could you provide it? Thanks.

 (1) a sample file, you can replace raw data with bogus data to protect your privacy.

     or provide some sample data that fully covers your issue/question.

(2) give your expected result and its math formula based on the sample you provide.

Kindly note: Please ensure the data in sample is concise and representative.

Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@u92690 ,Not very clear to me
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

But refer if this HT file with employee Age can help