Forum Discussion

jonnyA's avatar
jonnyA
Responsive Resident
4 years ago

Help with an error on a formula

Can someone help me out with what I need to do to make this formula to work?  I dont understand the error? 

Below is part of the original formula.

 

 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    jonnyA , Seem like you are using the dataset that has some problem. Publish it again and check. I think one measure is missing.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi jonnyA ,

    Believe that by the error you are showing that you are creating a measure when doing that you need to do an aggregation that is why it's not working.

    Try to use the same formula but as a column.

    Just one additional tip on DAX you should always refer the measures and columns accordingly to the notation below:

    Column - Table[ColumnName]
    Measure - [MeasureName]

    If you do it like this you will identify faster the use of measures or columns in your formulas.

     

    If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.