Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hello,
Here's the short on the issue
I want to return the top category and value for this measure. However writing the dax for it gives me the wrong result.
I have the following measure calculating the difference between two snapshot values in a table as follows
Total R4Q ACV Motion LW % =
VAR CurrentPipe = CALCULATE (
SUM ( 'CX Pipe Motion'[ACV EUR] ),
REMOVEFILTERS( 'CX Pipe Motion'[Snapshot Short Desc]),'CX Pipe Motion'[Snapshot Short Desc] = "Today" && 'CX Pipe Motion'[DRM cont] in {"Active", "Booked/Won"} && 'CX Pipe Motion'[Closing Quarter] in {"2022-Q4", "2023-Q1", "2023-Q2", "2023-Q3"})
VAR LWPipe = CALCULATE (
SUM ( 'CX Pipe Motion'[ACV EUR] ),
REMOVEFILTERS( 'CX Pipe Motion'[Snapshot Short Desc]),'CX Pipe Motion'[Snapshot Short Desc] = "Today -7" && 'CX Pipe Motion'[DRM cont] in {"Active", "Booked/Won"} && 'CX Pipe Motion'[Closing Quarter] in {"2022-Q4", "2023-Q1", "2023-Q2", "2023-Q3"})
RETURN
((CurrentPipe - LWPipe) / LWPipe )
Now trying to get the MAX of this measure
I've used this to get the max category but i'm getting the above result instead.
Max LW R4Q Solution % =
MAXX(
TOPN(1, 'CX Pipe Motion', [Total R4Q ACV Motion LW %], DESC),
'CX Pipe Motion'[Solution Area L3]
)
Any ideas would be helpful.
Thanks a lot
Quentin
Solved! Go to Solution.
Can you please try below.
Max LW R4Q Solution % =
MAXX(
TOPN(1, VALUES('CX Pipe Motion'[Solution Area L3]), [Total R4Q ACV Motion LW %], DESC),
'CX Pipe Motion'[Solution Area L3]
)
Proud to be a Super User!
Hi,
Can you please share a clear screenshot and have some sample data . It is very hard to read and understand.
Proud to be a Super User!
Hi Farhan,
Here is the table. I expect the result to display the top solution by % change.
It's showing me a different solution than expected
Can you please try below.
Max LW R4Q Solution % =
MAXX(
TOPN(1, VALUES('CX Pipe Motion'[Solution Area L3]), [Total R4Q ACV Motion LW %], DESC),
'CX Pipe Motion'[Solution Area L3]
)
Proud to be a Super User!
Hi Farhan,
It's working if I change to ASC. Thank you!
Max LW R4Q Solution % =
MAXX(
TOPN(1, VALUES('CX Pipe Motion'[Solution Area L3]), [Total R4Q ACV Motion LW %], ASC),
'CX Pipe Motion'[Solution Area L3]
)
User | Count |
---|---|
92 | |
88 | |
88 | |
79 | |
49 |
User | Count |
---|---|
156 | |
145 | |
105 | |
72 | |
55 |