Open Tickets
Thanks to Phil_Seamark's insightful guidance and examples in his fantastic new book, Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence, I finally "get" the GENERATE fun...
I am using the above measure to count for number of homes under construction in each month, but I need to be able to use the value in order to divide by total $ amount spent in that month whcih is coming from a different table. I think because we are adding a column it is not giving me the correct number when dividing the two numbers. Do you know how I would calculate this correctly?