Forum Discussion
Help with DAX formula
Hello everyone, I want the below formula defined in a measure to group by month, but the dax'es I've tried is unable to group it by month. Hit_Rate%_15th = DIVIDE(COUNTROWS(FILTER('Placement S&OP...
More context:
Earlier, this measure was calculating data only for the November table, which contained 7k rows. After appending the October and December tables, the total row count increased to 19k. Now, I want the measure to calculate the hit rate specifically for October when October is selected in the slicer, and similarly for any other selected month, i.e, modify the above code so that it filters month effectively.