Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dax Formula Not adding up with filter

Hello Power BI Community, I have an issue with a DAX formula: Basically, I want to have a target # of hours per month that is fixed by 105,  so I divided 105 by # of Days in a month. Then, I multi...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 
    No. I am referencing [Target] as measure. Please try and let me know the results

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Tamerj1, those are all dax formulas not columns, so I cant use those formulas. Atleast, I dont think I can, cause I tried Target is not a column its a formula

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 
I know that. I was talking about the Provider ID and the Month columns. You may try the formula I've propose (Most prpobaly the 2nd one) and let me know how it goes. Thank you