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.
I have an 'On Target' measure that has been created from 3 separate tables - this is used on a matrix visual showing accounts/customers that are either on or below target.
Is there a way of doing a count of the accounts/customers that are on or exceeding their targets (all the positive values) and the same for negative values? Looking to show the % of accounts/customers that are on target vs those that aren't.
When I try adding a count measure the 'On Target' measure is not an option to select. Is this because already calculated measures cannot be used within another measure?
Solved! Go to Solution.
HI @AllyT11
Please try
Count +ve =
COUNTROWS (
FILTER (
ADDCOLUMNS ( VALUES ( 'Table'[Customer Account] ), "@OnTarget", [On Target] ),
[@OnTarget] > 0
)
)
Count -ve =
COUNTROWS (
FILTER (
ADDCOLUMNS ( VALUES ( 'Table'[Customer Account] ), "@OnTarget", [On Target] ),
[@OnTarget] < 0
)
)
HI @AllyT11
Please try
Count +ve =
COUNTROWS (
FILTER (
ADDCOLUMNS ( VALUES ( 'Table'[Customer Account] ), "@OnTarget", [On Target] ),
[@OnTarget] > 0
)
)
Count -ve =
COUNTROWS (
FILTER (
ADDCOLUMNS ( VALUES ( 'Table'[Customer Account] ), "@OnTarget", [On Target] ),
[@OnTarget] < 0
)
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
30 | |
27 | |
24 | |
22 |