Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a simple measure that is as follows:
What I need to accomplish is to make this measure conditional, based on the site:
If the Site equals 21201, then the formula should be:
AVG QTY PRODUCED = COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 4 DAY])
Otherwise, it should be:
AVG QTY PRODUCED = COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 5 DAY])
There is a need to look at the information as a whole, and separately, so I don't think separate measures will work.
Link to project mockup:
https://1drv.ms/u/s!Ar8mMAEgH9mzaiaJKQo9b7ZOR1I
This has been keeping me up at night. Any help is appreciated.
Solved! Go to Solution.
Have you tried hard code on it?
AVG QTY PRODUCED =
VAR _site = SELECTEDVALUE(TABLE[SITE])
RETURN
IF _site = 21201;
COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 4 DAY]);
AVG QTY PRODUCED = COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 5 DAY]))
Did I answer your question? Mark my post as a solution!
Ricardo
That's a good idea. This is what worked.
Have you tried hard code on it?
AVG QTY PRODUCED =
VAR _site = SELECTEDVALUE(TABLE[SITE])
RETURN
IF _site = 21201;
COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 4 DAY]);
AVG QTY PRODUCED = COUNT('SHIPMENTS OUT'[ORDER_NO])/SUM('CALENDAR'[DAYS WORKED 5 DAY]))
Did I answer your question? Mark my post as a solution!
Ricardo
That's a good idea. This is what worked.
User | Count |
---|---|
21 | |
20 | |
14 | |
10 | |
8 |
User | Count |
---|---|
30 | |
28 | |
13 | |
12 | |
11 |