Forum Discussion

Redraidas1's avatar
Redraidas1
Helper 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 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
)
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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super 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
      Helper I
      5 years ago

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

      😞

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    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