Forum Discussion

Redraidas1's avatar
Redraidas1
Icon for Helper I rankHelper I
5 years ago
Solved

Need help with Measure

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 aforement...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
Redraidas1
Icon for Helper I rankHelper I
5 years ago

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

😞