Forum Discussion
table visuals over a star schema without a metric displaying data relevant to other visuals
- 6 years ago
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.
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!!!!!
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