topic DAX measure does not return the same value more than 1 time in DAX Commands and Tips

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

Anonymous — Wed, 29 Mar 2023 09:07:22 GMT

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?

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

tamerj1 — Wed, 29 Mar 2023 09:22:09 GMT

Hi Anonymous
Please provide sample of the data

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

tamerj1 — Thu, 30 Mar 2023 06:43:22 GMT

Anonymous
Please try

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