Forum Discussion
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...
Anonymous
No. I am referencing [Target] as measure. Please try and let me know the results
tamerj1
Community Champion
Community ChampionHI Anonymous
The names of columns and tables and the relationships are not clear to me. However you may try
Target New =
SUMX ( SUMMARIZE ( 'Table', 'Table'[Provider ID], 'Date'[Month] ), [Target] )or
Target New =
SUMX (
CROSSJOIN ( VALUES ( 'Table'[Provider ID] ), VALUES ( 'Date'[Month] ) ),
[Target]
)
Hi Tamerj1,
In the formula you provided it references [Target} as a column, however I am unable to do that because its not a column its a DAX formula. I did try to use it but it didnt work. Sorry, maybe I am not understanding it properly? Is it referring to a column [Target} because if I try to put a measure in it, it does not accept it only a column.
- tamerj1
Anonymous
No. I am referencing [Target] as measure. Please try and let me know the results