Forum Discussion
Measure of measure
Hi,
this seem much better now but I've to notice that this works just if we work on a single table.
As you can imagine I can have in my model some filtert table aside.
For example, material Type or Month are actually part of a wider model that I need to filter through "star" table that drive all my model.
I have notice that this formula doesn't work with those table filter.
How can I manage this complication?
Beside that I have to notice even that I can do this job group by group but it doesnt in an overall view: you can see from this screen, In your eveluation can you even consider what it takes to make it work even from an overall point of view? this would be great!
Thanks
Community SupportHi Anonymous
Are meterial type and month from some Dim tables? And you will use fields from Dim tables to filter the report? Can you provide a small example model of that as well as the relationships? And what is the current result with those table filters and what is the expected result?
Jing
Hi,
yes I use Dim table to filter the report so i would need to set up measure basing on the star filter Dim tables.
Beside that I need to have a resoult that work even on total (the second question here over)
Thanks
- v-jingzhang
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
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