Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
96 | |
87 | |
68 |
User | Count |
---|---|
169 | |
133 | |
130 | |
103 | |
95 |