How to show only subtotal value

[DJSwezey]

I have a table that contains Country, State, Target Regions and number of dairy cows.

I do not want to see the number of dairy cows per each target region (last drill down row). I only want to see totals for State and for Country.

Any suggestions?

[CoreyP · Accepted solution]

Option 1, don't use target region in your visual. Option 2, write a DAX measure to only sum when it's not in context of target region. Something like Dairy Cows = IF( ISFILTERED( [Target Region] ) , BLANK() , SUM( [Dairy Cows] ) )

[DJSwezey]

This works great with only one acception: now I have nothing to drill down onto. When I use the measure as my value I cannot drill down into a Target Region

[Bhaktishete]

 

Create a measure to calculate the total number of dairy cows for each state. Use the following DAX measure:

Total Dairy Cows = SUM('YourTable'[Number of Dairy Cows])

Create a measure to calculate the total number of target regions for each state. Use the following DAX measure:

Total Target Regions = COUNTROWS(VALUES('YourTable'[Target Regions]))

[DJSwezey]

Im not sure what this is solving for?

If I am using a measure as my value for number of Dairy Cows and Beef Cows then I cannot drill down to the Target Region by State.