Forum Discussion
Anonymous
3 years agoNot applicable
DAX measure does not return the same value more than 1 time
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?
Anonymous
Please tryMFR = DIVIDE ( CALCULATE ( SELECTEDVALUE ( 'Table'[FR] ), ALLSELECTED ( 'Date' ) ), 12 )