Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |