Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I'm looking for Dax that show me the Total Countif (FirstDayofMonth = FirstDayofMonth and AreaID = AreaID and CityCode = CityCode and HoodID = HoodID).
My name of this table is: NadRe
This is the result:
Thanks All !
Go to Solution.
@dolevh you can simply use this measure
SUM ( 'Table'[Count] ),
ALLEXCEPT ( 'Table', 'Table'[FirstDayofMonth], 'Table'[HoodID] )
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
View solution in original post
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.
Hi,This shoudl do what you want:
I hope this helps and if it does consider accepting this as a solution!
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.