Forum Discussion
Community Championtable visuals over a star schema without a metric displaying data relevant to other visuals
Hi DebbieE ,
Assuming that when you refer to stakholder is the person table on your image from the model setup correct?
In the attach PBIX I have made the following setup:
As you can see all table are related with the fact table only.
The measure Total events is:
Total Events = DISTINCTCOUNT('Fact'[EventID])I have setup a table visualization with only the description and another with the name and the total events.
As you refer if I setup the model only like this I will not be abble to filter out the behaviour with other visualization because you are only picking up the disconnected value.
However if you do just a simple change in your setup of the table it will do the job. Add the measure that you created on the filter pane of the behaviour and select different from blank and everything will filter out.
Again is the row vs filter context and the way you setup your visualization at work see image below and PBIX attach.
This can have a more complex scenario if your measures and visualizations are different based on the models so some simple tweaks.
Hope his is similar to what you need.
Super UserHi DebbieE,
Excuse for insisting but if I don't have further information is difficult to help you or guide in the correct path.
Can you share trough private message the file or a mockup. Or can you make a model in Excel with simulated values in the tables in order I can have a model similar to yours and help you.
I know that can be sensitive data that is why I asking it privately or a mockup.
Community ChampionUnfortunalty I cant share the pbix so it may have to go unresolved for a while.
So I should be able to have a table of data without the measure in it that reacts to the other visuals, that use different dimensions and measures from the fact table.
Just knowing that is at least something
- DebbieE
Here is my blog post in an attempt to get all this written up
- MFelix
DebbieE ,
Sorry for being such a implicative and having so many questions but without understand the data is difficult to help out others as you for sure also know.
As refered there are a lot of workarounds depending on the way things are setup but talking about a simple model the easist way is to connect the table trough the common value in this case the measure that does no have blank values.
🙂 BTW Nice blog post
- MFelix
Hi DebbieE ,
Assuming that when you refer to stakholder is the person table on your image from the model setup correct?
In the attach PBIX I have made the following setup:
As you can see all table are related with the fact table only.
The measure Total events is:
Total Events = DISTINCTCOUNT('Fact'[EventID])I have setup a table visualization with only the description and another with the name and the total events.
As you refer if I setup the model only like this I will not be abble to filter out the behaviour with other visualization because you are only picking up the disconnected value.
However if you do just a simple change in your setup of the table it will do the job. Add the measure that you created on the filter pane of the behaviour and select different from blank and everything will filter out.
Again is the row vs filter context and the way you setup your visualization at work see image below and PBIX attach.
This can have a more complex scenario if your measures and visualizations are different based on the models so some simple tweaks.
Hope his is similar to what you need.
- MFelix
Can you share the measure syntax?
Can also be a question about the way you make the measure.
- DebbieE
Its not really about the measure in this instance
I just want to know if its possible.
So a table with three Columns from Dimension A
then a visual with a Column From Dimension B and a measure from Fact table
Dimension A and B are connected 1 to many to the fact table
In this case should clicking on the second visual have an effect on the first visual?
If its a yes, then I can do more digging with the understanding that it should work
- MFelix
Hi DebbieE ,
Answering you directly yes you can have a star schema and select values on a visualization and have another one filter out this is possible.
But on contrary to what you say this can be a problem with the measure, or with the connections in your model or with the simple setup of the visualization. Be aware that in PBI you have the row context and the filter context, measure don't use the row context so if you setup your measure incorrectly the interaction between the visualizations will not work.
I'm just trying to help you and achieve the best result but sometimes the theorical part does not match the models we have so we need to make ajustments to the connections or make additional columns or measure to have everything working properly.
Hope you can solve your issue and if you need anyfurther assistance please tell me.
- DebbieE
Let me have another go.
The table contains description data from Behaviour dimension (A)
The next visual Contains a description from table B (Stakeholder type from the Stakeholder Dimension) .... and for example a Measure for Total Events DISTINCTCOUNT(EventID) in the fact table
EventID has no connection at all to table A because the Event ID joins to Event Dimension C
So in this case, If you click on Stakeholder Type Manager Should the initial table then change to show all the Behaviours for Managers?
- tex628
Is there any relationship between table A and table B in your example?
/ J - DebbieE
thats absolutely what I needed
So you can get over this issue by aplpying a filter for Measure is not blank
fantastic
That will get me over the issue of users getting annoyed because they cant create their Table visuals without actually adding the measure to it
Thank you!!!!!
