Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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]
)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
107 | |
106 | |
91 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
93 | |
91 |