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 calculate this:
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi @Sibrulotte,
Try measure as:
Measure =
SUMX(VALUES('Table'[Delivery Date]),CALCULATE(Sum('Balance'[Market value]), Filter('Balance', 'Balance'[Year]=MAXX(Balance','Balance'[Year]))))
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi,
thank you for taking the time to respond!
I'm not quite sure what Table [Delivery date] does in the formula, so I can't realy replicate it since I'm not sure how to transpose it.
Year | StateName | Average Age | Average Balance | Market value |
2020 | NY | 40 | 100 | 5000 |
2021 | NY | 50 | 300 | 15000 |
2020 | KY | 50 | 400 | 10000 |
2021 | KY | 60 | 600 | 20000 |
2020 | CA | 20 | 50 | 100 |
2021 | CA | 30 | 150 | 300 |
2020 | FL | 40 | 500 | 20000 |
2021 | FL | 50 | 1500 | 40000 |
2020 | TX | 50 | 1200 | 6000 |
2021 | TX | 40 | 600 | 1000 |
and the result would be 76300 even if I have FL selected in a slicer
Hi,
You may download my PBI file from here.
Hope this helps.
Hi @Sibrulotte,
Try measure as:
Measure =
SUMX(VALUES('State'[StateName]),CALCULATE(Sum('Balance'[Market value]), Filter('Balance', 'Balance'[Year]=MAXX(Balance','Balance'[Year]))))
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |