Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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]
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
87 | |
66 | |
52 | |
46 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |