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.
Hello nice people =]
I have a problem with that thing here:
This is a shipping cost table. I need to get only the min value for each area (AC Capital, AC Interior, AL Capital, AL Interior and so on) and the name of the Shipping Company that has that value. Right now it gives me the min cost for each Shipping Company in my table.
Solved! Go to Solution.
@leonardoficz
Insert a table visual, add the Area and the following measure to it:
Min Value =
VAR __MINVAL = MIN(Table01[Min Shipping])
VAR __CO = CALCULATE( MAX(Table01[Shipping Co.]) , Table01[Min Shipping] = __MINVAL )
RETURN
__CO
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @leonardoficz ,
is it possible for you to share a sample file with sensitive data removed ?
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |