Measure to divide filtered numbers

[cammar]

Hi all,

I am looking for a measure to do the following:

use the FTEquiv column in the 'Sheet' table

filter to only include people that are tagged 'Block Contract' in the Tag column in the 'Activity' Table 

Thanks

[Anonymous]

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.