The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All,
I have data like below. I use the measure :
VLTH Launched Units Last =
SUMX (
VALUES ( Project[City] ),
CALCULATE (
LASTNONBLANKVALUE ( 'Calendar'[DATE], VLTH[VLTH Accumulated Launched Units])
)
)
The data show :
I want to find the measure to calculate the Lauched Unit Last for Provinces which have a beach ( Example : Khanh Hoa Province, Quang Ninh Province ) base on the measure VLTH Launched Units Last Value .
Launched Units Last Coastal =CALCULATE(VLTH[VLTH Launched Units Last], Project[City] IN {"Quang Ninh Province","Khanh Hoa Province"})
But the data show:
I know it wrong but can't fix it . Please help me how to seperate the result of Quang Ninh Province and Khanh Hoa Province in the data .
Solved! Go to Solution.
Try
Launched Units Last Coastal =
CALCULATE (
VLTH[VLTH Launched Units Last],
KEEPFILTERS ( Project[City] IN { "Quang Ninh Province", "Khanh Hoa Province" } )
)
Try
Launched Units Last Coastal =
CALCULATE (
VLTH[VLTH Launched Units Last],
KEEPFILTERS ( Project[City] IN { "Quang Ninh Province", "Khanh Hoa Province" } )
)
Thank you johnt75 so much !😀
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
32 | |
20 | |
16 | |
15 |
User | Count |
---|---|
74 | |
31 | |
30 | |
24 | |
21 |