Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I'm looking for Dax that show me the Total Count
if (FirstDayofMonth = FirstDayofMonth and AreaID = AreaID and CityCode = CityCode and HoodID = HoodID).
My name of this table is: NadRe
FirstDayofMonth | CustID | AreaID | CityCode | HoodID | Count |
1/1/21 | 11111 | 1 | 200 | 100 | 10 |
1/1/21 | 22222 | 1 | 200 | 100 | 20 |
1/1/21 | 33333 | 1 | 200 | 100 | 30 |
1/1/21 | 77777 | 2 | 400 | 10 | 100 |
1/1/21 | 66666 | 2 | 400 | 10 | 200 |
2/1/21 | 11111 | 1 | 200 | 100 | 1000 |
2/1/21 | 22222 | 1 | 200 | 100 | 2000 |
2/1/21 | 33333 | 1 | 200 | 100 | 3000 |
2/1/21 | 77777 | 2 | 400 | 10 | 10,000 |
2/1/21 | 66666 | 2 | 400 | 10 | 20,000 |
This is the result:
FirstDayofMonth | HoodID | Count |
1/1/21 | 100 | 60 |
1/1/21 | 10 | 300 |
2/1/21 | 100 | 6,000 |
2/1/21 | 10 | 30,000 |
Thanks All !
Solved! Go to Solution.
@dolevh you can simply use this measure
Measure =
CALCULATE (
SUM ( 'Table'[Count] ),
ALLEXCEPT ( 'Table', 'Table'[FirstDayofMonth], 'Table'[HoodID] )
)
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new table, and it uses SUMMARIZECOLUMNS function.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@dolevh you can simply use this measure
Measure =
CALCULATE (
SUM ( 'Table'[Count] ),
ALLEXCEPT ( 'Table', 'Table'[FirstDayofMonth], 'Table'[HoodID] )
)
Hi,
This shoudl do what you want:
I hope this helps and if it does consider accepting this as a solution!
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |