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.
Dear Please if anyone can help me with this measure :
Solved! Go to Solution.
@bhelou , Use filter
Population =
VAR
Population = CALCULATE(SUM(ESTIMATES[Pop Total Estimates]))
Return
CALCULATE([Pop Total Estimates running total in Year],filter('Capitals Unique', 'Capitals Unique'[Country] = SELECTEDVALUE('Capitals Unique'[Country])))
If these tables are joined, no need to add this clause
for more than one value
Population =
VAR
Population = CALCULATE(SUM(ESTIMATES[Pop Total Estimates]))
Return
CALCULATE([Pop Total Estimates running total in Year],filter('Capitals Unique', 'Capitals Unique'[Country] in allselected('Capitals Unique'[Country])))
@bhelou , Use filter
Population =
VAR
Population = CALCULATE(SUM(ESTIMATES[Pop Total Estimates]))
Return
CALCULATE([Pop Total Estimates running total in Year],filter('Capitals Unique', 'Capitals Unique'[Country] = SELECTEDVALUE('Capitals Unique'[Country])))
If these tables are joined, no need to add this clause
for more than one value
Population =
VAR
Population = CALCULATE(SUM(ESTIMATES[Pop Total Estimates]))
Return
CALCULATE([Pop Total Estimates running total in Year],filter('Capitals Unique', 'Capitals Unique'[Country] in allselected('Capitals Unique'[Country])))
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 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |