Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm trying to wrap my head around this. I've attached the model here: https://drive.google.com/file/d/1yIC3LKIDAaCzr5LbQyg5k6w2p4poSNB3/view?usp=sharing
Also see screenshot of the model below and the expected end result.
The expected result is a bar chart where you can filter on project, supplier name and date. The Y-axis will be sales for the total number of projects and the X-axis will be dates based on project starts. Example: the value of project id 1 is 10 700, and the value of the project start in 2024-05-08 is 3 * 10 700 = 32 100. So:
Data
Thanks for any help
Solved! Go to Solution.
Hi @carlenb
Please refr to attached
Sales Volumne =
SUMX (
VALUES ( DimProject[ID] ),
SUMX (
CALCULATETABLE ( Sales ),
Sales[Quantity] * Sales[Price]
)
* CALCULATE ( MAX ( DimProjectPlan[Number of starts] ) )
)
Hi @carlenb
Please refr to attached
Sales Volumne =
SUMX (
VALUES ( DimProject[ID] ),
SUMX (
CALCULATETABLE ( Sales ),
Sales[Quantity] * Sales[Price]
)
* CALCULATE ( MAX ( DimProjectPlan[Number of starts] ) )
)
Many thanks @tamerj1 - I got it to work as expected 🙂 thanks for submitting the solution as well!
Added the following example in the thread start:
The value of project id 1 is 10 700, and the value of the project start in 2024-05-08 is 3 * 10 700 = 32 100.
User | Count |
---|---|
51 | |
27 | |
19 | |
18 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
23 | |
22 |