Forum Discussion
Solved
Need Help - Divide based on multiple criteria
Hi All, Hope you are well. I am new to power BI and trying to create a report and need your support with DAX measure. Below is a sample table where i have MWD spent by month. I am looking for ...
Hi geetika3110 ,
According to your description, here's my solution.
To be divided by = IF ( MAX ( 'FTE'[Month] ) IN { "Jan", "April", "July", "October" }, 19.125, 15.3 )FTE = DIVIDE ( SUM ( 'FTE'[MWD] ), 'FTE'[To be divided by] )Get the result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi geetika3110 ,
I have a solution:
This is the measure I used:
TomsFTEMeasure =
CALCULATE (
DIVIDE (
SUM ( Table18[MWD] ),
IF ( CONTAINSROW ( {"Jan", "Apr", "July", "October"}, MAX ( Table18[Month] ) ), 19.125, 15.3 )
)
)
Does this solve your issue? 🙂
/Tom
Thank you so much for your revert,
When i try to count rows using above formula, it is asking for a table and i am not able to select the column that contains "period" or "Month"
( {"Jan", "Apr", "July", "October"}