Forum Discussion

Tuan's avatar
Tuan
Helper III
6 years ago

Measure - Excluding filter from Filter Pane

Hello,   I can't seem to figure this one out. I'm trying to use a measure that excludes a filter on the Filter Pane. I'm creating product cards in which I select one product at a time.  I'm trying ...
Need Help
Icey's avatar
Icey
Community Support
6 years ago

Hi Tuan ,

 

How about this?

Stores (All Products) = 
CALCULATE (
    DISTINCTCOUNT ( DimStore[Store] ),
    FILTER ( ALL ( DimProduct[Product]), [Net Sales] > 0 )
)

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Tuan's avatar
Tuan
Helper III
6 years ago

That doesn't quite work as it gives me Store count for zero sales weeks, I believe the net sales >0 part of the formula is not working correction as shown by the picture below. I got it to work using the formula below. For some reason it doesn't work on my actual data, maybe due to my connections, which im still trying to figure out.

 

New link with my live calendar

https://drive.google.com/file/d/1hxEgV-ZYCWUJ2OBkoqiWDGb-UkBsasph/view?usp=sharing

 

 

 

Stores (All Products) 2 = 
CALCULATE (
    DISTINCTCOUNT ( DimStore[Store]),
    FILTER (
        ALLEXCEPT (
            'FactData',
            'DimStore'[Region],
            'DimDate'[Week]
        ),
        [Net Sales] > 0
    )
)