Forum Discussion
Measure of measure
Hi Anonymous
The measure should also work in this model. Can you show its current result and expected result by taking some data as example?
If you use columns from Dim tables in the table visual, you can try using these columns in SELECTEDVALUE function to replace corresponding columns from Fact table. But as the tables are related, maybe the result is same.
Jing
Hi,
actually the model is working even with filter on DIM table. The behaviour I'm not still able to obtain is the following.
I'm able to have the rotation index over a single family but, if I select all the family or even just two it doesn't give me back the index.
In my model I have the "Plant" in which I have many families: what I need to have is a total consumpion (and as a consequence the rotation index) even for the sum of all the families.
Here the example of what I've: with one family it works
With two or more it stops to return me the desired value of total consumption and IR as a consequence
please help me to solve this
- Anonymous4 years agoNot applicable
Hi,
is there any update I can have here? still no answer from a long time. If no solution can be provided I need to re think my model
Thanks