Forum Discussion
DAX Formula, Filtering Complications
Hello, community! So I have a formula that should compute the total hours for work efforts in an organisation. These efforts are booked in certain accounts, and in these accounts there are certai...
Hi sambgv in your measure definition, part SUMMARIZE (after CALCULATE) is written what you want to calculate
'FACT_Table1' [ID_acct_project_user_mth]
Depending what is your details of fact table (team ID, member id, hours / minutes...) and what is your request for aggregation, define your measure.
This stand for your monthly level of data. Sometimes, simple caclulated columns could "enrich" your initial inputs for your outputs.
Check your inputs and level of output. I hope this help