Showing measure from a table not filtered.

[XAVICHETAPIA]

Dear,

Here my case ( schema) and my doubt.  

I guess it have to be solve through a formula that affect the relation, but I cannot find it. Thank you in advance.

This is the schema. 

I have one measure done trhough a column of Table: Price  

Price measure = sumx('PRICE','PRICE'[PRICE])

And anhother measure done through a colum of table: LEADTABLE.

LEAD measure = AVERAGEX(LEADTABLE,LEADTABLE[LEAD])

Doubt

What I need is when filtering by month, only see the reservations with Price on this month ( yellow one )

What I actually see is, all the reservations independing of the month filter.

Those are my tables.

THanks,

Adrián

[NickolajJessen]

The soloution posted answered your query:

---

@XAVICHETAPIA wrote:

What I need is when filtering by month, only see the reservations with Price on this month ( yellow one )

What I actually see is, all the reservations independing of the month filter.

---

The soloution can't be used to filter data on a Card Visual, however.

If you share your .pbix, i'll whip up a quick measure for ya 

[XAVICHETAPIA]

https://drive.google.com/file/d/1iLDTl9MnbrAMSF0lHO1Zbf1ePrGoS8NP/view?usp=sharing

can you see it?

[NickolajJessen]

Ahh i see, the reason your month isn't filtering the LeadTable is because there is no link between Dates and LeadTable.

You should look into how to create a caldar table and how to manage relationship in a data model.
Avi Singh is a good resource for this.

[NickolajJessen]

Hi, 

Can you use the filter pane and filter out lines that are not above 0?

[XAVICHETAPIA]

The solution is not valid as all as If I create a Target with the "LEAD Measue" it doesn't change with month filters.

Example. Withouth filtering.

Filtering by month.

Thanks