Forum Discussion
Countifs in DAX
joerykeizer a few comments from me.
1. RANKX is the correct formula for what you need.
2. 30k records is a tiny tiny data model (micro in fact).
If you have performance issues with this size data model, it is most likely because your table strucutre is not optimal. How many columns do you have in your data table? I am guessing it is quite a few. Your aim should always be to only bring in columns you need, and also unpivot data when possible. Generally speaking, a table with 5 columns and 300k rows will be much faster than a table with 15 columns and 30k rows.
Can you share your table structure?
Hi Guys,
I am very new to PowerBI and knows nothing about DAX. I have the excel formula in the image below. Basically i want to know how to write a DAX formula that counts how many times the SERIAL NUMBER occured in a specific month, for the example below i filtered the pivot only October 2016 but i will be displaying 13months as you can see in the table in the top.