Forum Discussion
Dax formulas work and no work
Also, if i just paste part of my new data in my excel and refresh, only the second dax formula (Rec. Otorgados Manager) doesn´t work. The first one does!
thanks!!
Anonymous -
The function LOOKUPVALUE only can return a single value (Scalar).
If more than one value meets the criteria that you provide, that will cause an error.
In your first example, if there is more than 1 [estado] associated with a user/manager, the calculation will fail.
In your second example, if there is more than 1 [Cantidad de reconocimientos otorgados] associated with a user/manager, the calculation will fail.
You either need to provide more filters, or use a different calculation.
Hope this helps,
Nathan
I just understand the difference why in one works and in the other one don't.
I have the data of all the employees (including managers and no managers) with columns such as the quantity of recognitions they gave and the name of his manager.
I create another column beside the managers name with the "Estado/Status" (first formula) and how many recognitions they gave (the second i used). Which other formula would you recommend?
thanks!!
Anonymous - The calculation depends on what you're trying to achieve. Could you provide some sample data and expected result. Especially important is what do you want to happen when there is more than one value row with the same employee / manager?
I think i understandthe problem. When there are 2 months in the power bi, there are 2 different results, thats why figures ERROR. When I only leave one month, this doens´t happen.
Is there a way I can include in the formulas I already have a filter that is sincronized with my slicer Month?
thanks a lot again Anonymous !!