Forum Discussion
measure
Hello,
I found solution with measure (distinctrows, filters, calculate, ...), thats great.
then i create another to get my results.
Thank you for your help :)
I would certainly recommend doing the 3 measures and then creating that 4th measure to combine them all. This gives you the advantage of breaking the problem down into small chunks and solving individually. You also get the benifit that you can re-use these measures in other calculations that might use some of the same logic.
If you are concerned about performance, it will really only be a concern if you have to reference the same measure more than once within your code. If that was the case, DAX offers variables allowing you can store the result of your measure and use that result multiple times. This is done by starting your code with a "VAR variableName = [YourMeasure]" and placing a "RETURN" after all variables.
Good morning ROSS,
Thank you in advance for your reply and for your advices, they are precious.
Could you help me in the creation of these measures, I have never made such measures and even less a fourth one that takes them all back.
A big thank-you
Sure, can you post some example data?
Good night Ross,
what kind of example data you need ? name of table ? field name ?
Just a simple example of what the tables look like. You don't need to show me everything, just enough to get an idea of how many tables you have, what the relevant fields are, and any fields that might relate those tables.
You use a lot of words like "Folders" for what you need to calculate. Without seeing the data, its fairly meaningless.