Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 try

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

2 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion

    Anonymous 
    Please try

    MFR =
    DIVIDE (
        CALCULATE ( SELECTEDVALUE ( 'Table'[FR] ), ALLSELECTED ( 'Date' ) ),
        12
    )
  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous 
    Please provide sample of the data