Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I would like to count the number of projects with status "Completed" based on an inactive date relationship "Actual Completion Date".
I used the following command:
Solved! Go to Solution.
Hi Denis,
I've managed to fix the issue using a different approach and it worked!
Completed = CALCULATE([Total Projects], 'FACT Project'[Status]="Completed", USERELATIONSHIP('DIM Dates'[Date], 'FACT Project'[Actual Completion Date]))
I basically created a new measure to count all the projects first, and thereafter filter it with the status then use the inactive relationship.
Hey @omd001 ,
use the FILTER as an argument for CALCULATE and just count the rows of the basic table. This will be filtered by the arguments in CALCULATE.
So try the following approach:
Completed =
CALCULATE(
COUNTROWS( 'FACT Project' ),
FILTER(
'FACT Project',
'FACT Project'[Status] = "Completed"
),
USERELATIONSHIP ( 'DIM Dates'[Date], 'FACT Project'[Actual Completion Date] )
)
Hi Denis,
I've managed to fix the issue using a different approach and it worked!
Completed = CALCULATE([Total Projects], 'FACT Project'[Status]="Completed", USERELATIONSHIP('DIM Dates'[Date], 'FACT Project'[Actual Completion Date]))
I basically created a new measure to count all the projects first, and thereafter filter it with the status then use the inactive relationship.
Thanks Denis.
It's strange that it only returned 2 rows of data and I am expecting more. I have no filters causing this so I wonder why it is not returning the expected results.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |