cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBISean Regular Visitor
Regular Visitor

Re: Customers who made sales in ALL of selected years

THANK YOU!

Highlighted
Super User
Super User

Re: Customers who made sales in ALL of selected years

Hi @PBISean 

 

My apologies for late reply.

 

In the question tab, you can use this MEASURE. I have highlighted the changes from your formula in red color.
KEEPFILTERS will ensure that all context filters from inside the Matrix come into play

 

SalesofRepeatCustomersCalc =
CALCULATE (
    [Total Sales],
    KEEPFILTERS (
        FILTER (
            ALLSELECTED ( Sales[Customer] ),
            COUNTROWS (
                FILTER ( ALLSELECTED ( Sales[Year] ), CALCULATE ( SUM ( Sales[Sales] ) <> 0 ) )
            ) = [CountSelectedYears]
        )
    )
)

 

The earlier version of the MEASURE was created to work as  VISUAL filter. Thats why you dont see it in the Magic tab

PBIsean1.png

 

PBISean Regular Visitor
Regular Visitor

Re: Customers who made sales in ALL of selected years

Hi Zubair,

 

This is so cool. I don't know you can put a measure into the visual level filter. Thank you soooo much. 

 

Sean