use CALCULATE on a Measure

[Anonymous]

Good day Everyone,

I am stuck and this probably is easy but I could not find a way to do it. I have a Matrix visual that has "Accounts" column, "Country" column and "Percentage" (a measure I have created).

I can use CALCULATE([Total Accounts],Stastics2[Country] = "India") to filter the count of accounts per country.

I wanted to know how I can use CALCULATE to filter the percentage column since I wanted to know the count of accounts that has positive/negative percentage.

[Fowmy · Accepted solution]

@Anonymous 

Try the following two measures for Pos and Neg:

Positive Count = 
CALCULATE ( 
	[TOTAL ACCOUNTS],
	FILTER( Stastics2 , [Percentage] >= 0)
)


Negative Count = 
CALCULATE ( 
	[TOTAL ACCOUNTS],
	FILTER( Stastics2 , [Percentage] < 0)
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn