Need a measure to use a selected value from a slicer that has set no interaction with table

[Bokazoit]

I am trying to build a table with multiple selections that interacts with a measure. The selection page looks like this (dont mind the ugly colors - I am still building and testing 😄 )

The measure will depending on the choosen criterias alter the selection in the table. It works, but when I add the Date selection and the Støttetype selection, they work more like filters on my table instead of the measure itself. Maybe I am talking nonsense, so for my own sake I created a simple page, where I have a slicer from a parameter

The slicer is not active on the table and from what I can see the PriceChoice (= 10) is not entered into the measure 'Prio'

Prio = 

VAR PrisValg = CALCULATE(MIN(Brevpris[Brevpris]), ALLSELECTED(Brevpris))

VAR RFV = CALCULATE(([Direct mail Bidrag])/([Antal Direct Mails]*Brevpris[Værdien Brevpris]))

RETURN

IF ( [Antal Direct Mails] > 0 && RFV > 1, RFV)

If I create the measure 'PriceChoice'

PriceChoice = CALCULATE(MIN(Brevpris[Brevpris]), ALLSELECTED(Brevpris))

It shows the correct value

but not in the table. Is it at all possible to make this work? I need the interaction to be off, and only use the measure as the filtered value in the table if that makes sense

[Anonymous]

Hi @Bokazoit ,

Don't use allselected(), use all() and add filter condition.

Best Regards,

Jay

[Bokazoit]

Still return a zero:

PriceChoice = CALCULATE(MIN(Brevpris[Brevpris]), ALL(Brevpris[Brevpris]))