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...
Hi rit_ty7 - Since you are now working with 3 months of data and the existing formula is not filtering correctly
Hope you already have a proper date table in your model, you can use it to simplify the filtering
Hit_Rate%_15th =
DIVIDE(
CALCULATE(
COUNTROWS('Placement S&OP Nov'),
'Placement S&OP Nov'[Hit by 15th] = 1
),
COUNTROWS('Placement S&OP Nov'),
0
)
When using this, make sure the Year and Month fields from your date table are included in the visual, and the relationships between the date table and your fact table are correctly configured.