Forum Discussion
use CALCULATE on a Measure
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.
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 🙂
1 Reply
- Fowmy
Super User
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 🙂