Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
hi,
I need to get the sale of the area, using Id Department.
For Example, If filter by Area Metro, result should be $ 10,000.
Thank a lot.
Solved! Go to Solution.
Hi @Joshua_
try measure
= calculate(SUM('Sales Table'[Sales]); Filter(ALL('Sales Table');'Sales Table'[ID]=SELECTEDVALUE([ID_Area]))
do not hesitate to give a kudo to useful posts and mark solutions as solution
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
24 | |
17 | |
13 | |
12 | |
10 |
User | Count |
---|---|
33 | |
27 | |
16 | |
13 | |
12 |