Need help with Measure

[Redraidas1]

I'm trying to write a measure, that would ignore one of my slicers called DealerName , however, even though I specify this requirement by using ALL, it looks like my measure still takes the aforementioend slicer into consideration and shows the incorrect figure. Is there any way to fix this?

CALCULATE (

DISTINCTCOUNT ( AfterSalesWorkshopData[VIN] ),

ALL(Dim_Dealer[DealerName]),

FILTER (

AfterSalesWorkshopData,

AfterSalesWorkshopData[Qualifying Repair Order type] <> "Full"

),

FILTER (

AfterSalesWorkshopData,

AfterSalesWorkshopData[Segment] = _Segment

)

) + 0

)

[v-deddai1-msft · Accepted solution]

Hi @Redraidas1 ,

What's the relationship between AfterSalesWorkshopData and Dim_Dealer? Would you please try to use the following measure:

measure1 =
CALCULATE (
    DISTINCTCOUNT ( AfterSalesWorkshopData[VIN] ),
    FILTER (
        AfterSalesWorkshopData,
        AfterSalesWorkshopData[Qualifying Repair Order type] <> "Full"
    ),
    FILTER ( AfterSalesWorkshopData, AfterSalesWorkshopData[Segment] = _Segment ),
    REMOVEFILTERS ( Dim_Dealer[DealerName] )
) + 0

If it doesn't work, I also suggest to edit interaction between slicer and the visual which hold the measure.

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

Best Regards,

Dedmon Dai

[amitchandak]

@Redraidas1 , Try

CALCULATE (
DISTINCTCOUNT ( AfterSalesWorkshopData[VIN] ),
ALL(Dim_Dealer),
FILTER (
AfterSalesWorkshopData,
AfterSalesWorkshopData[Qualifying Repair Order type] <> "Full"
),
FILTER (
AfterSalesWorkshopData,
AfterSalesWorkshopData[Segment] = _Segment
)
) + 0
)

or

CALCULATE (
DISTINCTCOUNT ( AfterSalesWorkshopData[VIN] ),
removefilters(Dim_Dealer[DealerName]),
FILTER (
AfterSalesWorkshopData,
AfterSalesWorkshopData[Qualifying Repair Order type] <> "Full"
),
FILTER (
AfterSalesWorkshopData,
AfterSalesWorkshopData[Segment] = _Segment
)
) + 0
)

[Redraidas1]

Doesn't work, still won't ignore Dim_Dealer[DealerName] 

😞