DAX measure does not return the same value more than 1 time

[Anonymous]

Hey everyone,

So, the problem is that a fairly simple measure does not return a value twice or more if the value of 'Measure 1' is same:

MFR = 

DIVIDE (
         SELECTEDVALUE('Table'[FR]), 12
)

As you can see, after returning 8 once, it doesn't do anything until it gets 9, then 10. There are three 10 values, and it returns only one of them. Same issue with other values.

How do I fix it so it could return values?

[tamerj1 · Accepted solution]

@Anonymous 
Please try

MFR =
DIVIDE (
    CALCULATE ( SELECTEDVALUE ( 'Table'[FR] ), ALLSELECTED ( 'Date' ) ),
    12
)

[tamerj1]

Hi @Anonymous 
Please provide sample of the data