topic Re: Measure Help in DAX Commands and Tips

Measure Help

mkane12 — Fri, 11 Apr 2025 21:30:54 GMT

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))

Re: Measure Help

lbendlin — Fri, 11 Apr 2025 22:29:39 GMT

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

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

Re: Measure Help

mkane12 — Mon, 14 Apr 2025 13:53:19 GMT

thanks, but unfortunately this did not work.

Re: Measure Help

lbendlin — Mon, 14 Apr 2025 14:02:26 GMT

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.

Re: Measure Help

mkane12 — Mon, 14 Apr 2025 14:30:34 GMT

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:

Re: Measure Help

lbendlin — Mon, 14 Apr 2025 14:33:44 GMT

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

Re: Measure Help

mkane12 — Mon, 14 Apr 2025 14:39:04 GMT

Re: Measure Help

lbendlin — Mon, 14 Apr 2025 14:46:43 GMT

Re: Measure Help

mkane12 — Mon, 14 Apr 2025 15:26:29 GMT

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

Re: Measure Help

lbendlin — Mon, 14 Apr 2025 15:11:42 GMT

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

Re: Measure Help

v-aatheeque — Sat, 19 Apr 2025 17:56:01 GMT

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!

Re: Measure Help

DAXian — Sat, 19 Apr 2025 20:49:23 GMT

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!

Re: Measure Help

v-aatheeque — Wed, 23 Apr 2025 11:43:21 GMT

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!