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 moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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]
)
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
85 | |
84 | |
73 | |
49 |
User | Count |
---|---|
143 | |
132 | |
110 | |
66 | |
55 |