Forum Discussion

rit_ty7's avatar
rit_ty7
Icon for Advocate I rankAdvocate I
1 year ago

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...
Need Help
Tips and Tricks
Tutorial Requests
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
1 year ago

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.