Need help in DAX formula

Solution Supplier

2 years ago

Here’s how you can achieve this:

Create a New Measure:
- Go to the Modeling tab in Power BI.
- Click on New Measure.
- Name your measure (e.g., “Crew with 5+ Projects”).
Calculate Crews with 5 or More Projects:
- Use the following DAX formula for your new measure:
```
Crew with 5+ Projects =
CALCULATE(
    [Distinct Crew Count],
    FILTER(
        ALL(merged_allocation_daily),
        [Distinct Crew Count] >= 5
    )
)
```
- Replace [Distinct Crew Count] with your existing measure for distinct crew count (e.g., DISTINCTCOUNT(merged_allocation_daily[Crew Sys ID])).
Update Your Visual:
- Now, use the new measure “Crew with 5+ Projects” in your visual instead of the previous “# of Projects” measure.
- Apply any necessary filters to your visual.

Forum Discussion