Hi @cammar ,
You can create a measure in Power BI by going to the "Modeling" tab and selecting "New Measure". Here's an example measure that should accomplish what you're looking for:
FTEquiv Block Contract =
CALCULATE (
SUM ( Sheet[FTEquiv] ),
FILTER ( Activity, Activity[Tag] = "Block Contract" )
)
This measure uses the CALCULATE function to sum the FTEquiv column in the Sheet table, but only for rows where the Tag column in the Activity table is "Block Contract". You can name the measure whatever you like, and then use it in your visuals just like any other measure.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
