Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I would like to count the Met/Not Met category I have developed for transit times and lead times. One complication is that these categories are on different excel files.
Here's images of the model:
The file 'Ocean Shipment Tracker' has individual shipment data, including transit times, whereas 'Ocean LT' has planning lead times (named 85% Confidence here) according to lane name. The two files are connected using lane names. (This means there are multiple transit times associated with each lane name, but only one planning lead time associated with each lane name.)
Here's the code I am using right now (I am new to DAX and PowerBI, so if there is a more efficient way of doing this, please let me know!):
Ocean Met =
Var a =
SUM('Ocean Shipment Tracking'[Actual transit time])
Var b =
SUM('Ocean LT'[85% Confidence])
Return
IF(a<b, "Met","Not Met")
This allows me to add a column in a table, but I can't figure out how to get a count of "Met" shipments:
(the third column 'Recommended Planning LT' is the '85% Confidence')
When I try to put this into a card, I get "Not Met". Under 'Fields', there is no option for 'Count'.
Any help on counting Met/Not Met would be greatly appreciated.
Thank you!
That data model looks suspicious. Please familiarize yourself with the concept of "fact" and "dimension" tables, and how they should be linked. Usually you do not want to directly connect two fact tables, and especially not via a M:M bidirectional connection.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |