Visuals not matching up

[NJ81858]

Hello,

I have 2 visuals that follow the same principal: they show the goal and the actual value for a metric, but only will show data that is before the selected report month. They each have measures that help to accomplish this that go like this:

Backlog = IF(MAX([Date Field]) < [End Date], 1, 0)

and the End Date Measure goes like this:

End Date = 
VAR _month = SELECTEDVALUE([Month]) + 1

RETURN

DATE(YEAR(TODAY()), _month, 1)

From there I set each visual to only show data when the Backlog measure is 1. The issue that I am having is that one works perfectly, showing no data at all when there is no selected month, but the other one still shows the goal data for each group, when it shouldn't show at all. The only difference between the two tables is that the value for the metric comes from different tables, but everything else comes from the same table.

Unfortunately I cannot share my pbix file, as there is very sensitive data in there, so I will try and lay out my situation as best I can in here:

My ID/Goal table looks similar to this:

	Metric 1 Goal	Metric 2 Goal
Group 1	5	25
Group 2	6	20

I have tables for each of my metrics that look like this for each metric (note this is only for one metric, since both follow the same structure) :

	Metric 1 Value	Date
Group 1	3	12/1/2022
Group 2	2	12/1/2022
Group 1	1	11/1/2022
Group 2	8	11/1/2022

My visuals that I am building look like this (for this example, my selected month will be December, which will sum all months of data per group) :

	Goal	Value	Percent of Goal Reached
Group 1	5	4	80%
Group 2	6	10	166.67%

Note in this table, that the Group name and the goal come from the ID/Goal Table, and the value is a sum from the metric table.

When no month is selected I want my visuals to look like this(Since there is no selection for month, no data will be shown) :

	Goal	Value	Percent of Goal Reached

In case the final product isn't clear, here is my visual that does work correctly, note that I have no month selected:

Here is the visual that isn't working correctly, no month is selected for this image as well:

I'm just not sure if this is a bug or if something is wrong with my data, but everything is the same between the two visuals, relationships, aggregation, measures, etc. The only thing that is different is the Value column that is coming from each metric table. Thank you in advance!

[Anonymous]

Hi @NJ81858 ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[NJ81858]

@Anonymous As I posted in my original post, here is the table that I would like to see, with no Month selected:

This is the other visual with no month selected, and this visual is showing things incorrectly:

When I select a month, this is what the Green (correct) visual looks like:

This is what the Red visual looks like when I select a month (note that this is how it is supposed to work) :

Also all of the relationships between the tables are the same. The Group/Goal table is related to each Value table via a Many-to-One (Value to Group) with a single cross filter going towards the Value tables. Here is a glimpse at the model and the relationships from my Value tables (Black) to the Date Table, and my Group/Goal table (Blue) :

Essentially what I am after is a visual that will show no data when there is no month selected, and when a month is selected, will populate with data. I know that I have the process correct because it works for the Green visual correctly, it just shows the groups in the Red visual, even when no month is selected, which is wrong.