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. Please look at the last column (LOSS wrt MED TRIP IN).
My expected output is that this table will only show PAC=PTTEP because for year 2021, only PTTEP has a value of LOSS wrt MED TRIP IN. I don't know why my table is showing the value for all PAC. Even though the value of LOSS wrt MED TRIP IN in PAC other than PTTEP is 0, it is still wrong because still showing other PAC.
This is my measure.
Btw this is the filter that I'm using for this page
Where can I change so that I will only show the data for selected year?
Solved! Go to Solution.
@Anonymous , +0 force left join. remove that and try
LOSS wrt MED (TRIP IN) = (SUMX(ODBS_FTO_BHA,DIVIDE(ODBS_FTO_BHA[Minus MED TRIP IN],24,0)*(ODBS_FTO_BHA[RIG_COST]*1000)))
@Anonymous , +0 force left join. remove that and try
LOSS wrt MED (TRIP IN) = (SUMX(ODBS_FTO_BHA,DIVIDE(ODBS_FTO_BHA[Minus MED TRIP IN],24,0)*(ODBS_FTO_BHA[RIG_COST]*1000)))
Thank you!!
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 |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |