Possible to have a dynamic measure: Subtraction

[Anonymous]

Hi guys,

is it possible to create a dynamic measure? I want to subtract two dynamic parts. For example i have 10 numbers and want to subtract them in all possible combinations only in one measure. Is that possibe with filters/slicers?

Thank You

Best regards

[amitchandak · Accepted solution]

@Anonymous , Not very clear, but with an independent slicer, you can create two set products to filter

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

better example with date table

Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

If not

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Thanks. Looks promising. WIll try it