How to filter with a sumx measure that creates a visual table

[madepassionned]

When I create a measure with sumx that creates a visual table, I can only filter in the matrix and or table.
The question is that I want to gain insight into whether the traffic of our website fills hotels that are not filled by the competitor. Sometimes we fill hotels together and sometimes we cover it because they can't do it.

The two measures come from two aparate fact tables.

measure 1 SUM X Covering competitor =

var hotel_c =

CALCULATE(IF([weekplanning_competitor] >= 1,1,0 ))

Return

 SUMX(addcolumns(summarize(

  'Total_planningcompetitor','Total_planningcompetitor'[name_hotels],'Total_planningcompetitor'[week_number]),

    "p", hotel_c),[p])

measure 2  SUM X Covering  =

var hotel =

CALCULATE(IF([weekplanning] >= 1,1,0 ))

Return

 SUMX(addcolumns(summarize(

  'Total_planning','Total_planning'[name_hotels],'Total_planning'[week_number]),

    "w", hotel),[w])

For the filtering of the matrix and table I use this measure. But could I also process this in measure 1 & 2, for example?

measure 3 Correction sumx = IF(([SUM X Covering competitor] =  

[SUM X Covering ]) && [SUM X Covering competitor] <> BLANK() && [SUM X Covering] <> BLANK(),1,0)



The outcome I need to have to use it in other visualizations



I hope someone can help me. Thanks in advance.

[amitchandak · Accepted solution]

@madepassionned , You can use visual level filter

or

Sumx(filter(Values(Table[Name_of_hotel]), [SUM X Covering] =1) , [SUM X Covering])

[msbiuser1]

Yes @saravanan_p  that works. @madepassionned Hence the solution, simple. Kindly mark it as solution plz

[amitchandak · Accepted solution]

@madepassionned , You can use visual level filter

or

Sumx(filter(Values(Table[Name_of_hotel]), [SUM X Covering] =1) , [SUM X Covering])

[saravanan_p]

Your logic is wrong, it yeilds all data for all sumx coverng = 1. And @madepassionned  how can this get acccepted as solution. Anyways keep community healhty by supporting other non super users too.

[madepassionned · Accepted solution]

This works : 

Filter covering =

Sumx(FILTER(Values('table[Name_of_hotel]),

[SUM X Covering competitor] = BLANK() && [SUM X Covering]=1),

[SUM X Covering])

[madepassionned]

It does not work in the filterpane for a another visualisation.. only for a matrix or table

[saravanan_p]

Use filter pane and go to field weekplanning_Competetor and uncheck other values and check only blanks. Your result would be populated. 

KIndly give thumps up and mark as solution