Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have a matrix with the following rows in a hierarchy:
Client
MonthYear
Office
Agent
Recipient ID
I want to make a measure to display the target but only at the MonthYear level so it would show something like this:
Client Target
Dudes
Gents
Client Target
Dudes
Oct 2021 60
Nov 2021 40
Gents
Oct 2021 80
Nov 2021 21
Client Target
Dudes
Oct 2021
Chicago Office
London Office
Nov 2021
Chicago Office
London Office
Gents
Oct 2021
Beijing Office
Sydney Office
Nov 2021
Beijing Office
Sydney Office
Targets are only at a client level but are updated every month. How would I go about achieving this?
I think I have gotten a measure that calculates it, but so far it does it all the way down the hierarchy when really I only want it done on the rows with MonthYear
Solved! Go to Solution.
Hi, @spitfyah ,
I test a simple example. and you could refer it.
Measure = IF(ISINSCOPE('Table'[Client]),IF(ISINSCOPE('Table'[Date]),SUM([Target])))
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @spitfyah ,
I test a simple example. and you could refer it.
Measure = IF(ISINSCOPE('Table'[Client]),IF(ISINSCOPE('Table'[Date]),SUM([Target])))
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
you're on the right track with ISINSCOPE() but you may also have to add NOT ISINSCOPE() for the other levels.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |