Measure Help

[mkane12]

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
carrier5	1

the # from this example would be 2 carriers shipped one time.

I'm a little new to power Bi so bear with me. 

This is what I did but it just counted all the carriers:

One & Done = CALCULATE(DISTINCTCOUNT(McLeodIQ_Operations[Carrier.Carrier ID]),FILTER(McLeodIQ_Operations,McLeodIQ_Operations[Orders]=1))

[DAXian · Accepted solution]

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!

[v-aatheeque]

Hi @mkane12 ,

If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.

If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!

[lbendlin]

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

One n Done = countrows(filter(McLeodIQ_Operations,[Orders]=1))

[mkane12]

thanks, but unfortunately this did not work. 

[lbendlin]

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]

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]

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

[mkane12]

[lbendlin]

[mkane12]

it isn't working because it's just counting all the orders 

[lbendlin]

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

[v-aatheeque]

Hi @mkane12 ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!