Forum Discussion

mkane12's avatar
mkane12
Helper I
1 year ago
Solved

Measure Help

I am trying to create a measure counting any carrier that only shipped one order.    for example: carrier ID volume(orders) carrier1 200 carrier2 1 carrier3 20 carrier4 13 c...
Measures
  • DAXian's avatar
    DAXian
    1 year ago

    Hi mkane12 
    First I have assumed that volume is :

    Volume = SUM(McLeodIQ_Operations[Orders])


    I have created two solutions for you. The first one :

    One n Done = CALCULATE(DISTINCTCOUNT(McLeodIQ_Operations[Carrier.Carrier ID]),FILTER(ALLEXCEPT(McLeodIQ_Operations,McLeodIQ_Operations[Carrier.Carrier ID]),[Volume]=1))

     

    and the other one :

    Only One n Done =
    CALCULATE(
        DISTINCTCOUNT(McLeodIQ_Operations[Carrier.Carrier ID]),
        FILTER(
            SUMMARIZE(
                McLeodIQ_Operations,
                McLeodIQ_Operations[Carrier.Carrier ID],
                "TotalVolume", SUM(McLeodIQ_Operations[Orders])
            ),
            [TotalVolume] = 1
        )
    )  

     

     

    I've tried to replicate your column names btw. on the left, there is no date filter. so there will be 4 distinct count if order id is respected. and blank is returned for 'Only One n Done' since Carrier B has other others in April 2025. 

    On the right, we applied a date filter to only consider the whole month on March 2025. and so 1 was found for having a total volume = 1 for the whole month of march.

    I hope this solves your problem. let us know if this works!

     

     

     

lbendlin's avatar
lbendlin
Super User
1 year ago

you get points for the cool table name, and points deducted for the ampersand.

 

One n Done = countrows(filter(McLeodIQ_Operations,[Orders]=1))
mkane12's avatar
mkane12
Helper I
1 year ago

thanks, but unfortunately this did not work. 

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Please provide a more detailed explanation. What have you tried and where are you stuck?

    I tested the measure on my side and it seemed to work.

    • mkane12's avatar
      mkane12
      Helper I
      1 year ago

      the measure itself worked, but it didn't give me the solution I need. I need to count how many carriers had a volume of just 1. Your solution counted a lot more it seems, as the number should be less than what the carrier count is. 

       

      i need this counted:

      this is not right:

       

       

       

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        Please provide sample data that fully covers your issue.
        Please show the expected outcome based on the sample data you provided.