Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi friends
I would like some help.
I have a fTable with some product revenue values, return values, transfer...etc and I made a rankx to show de best selling product.
(using top N)
And I'm using an external filter on table
Read "1-Faturamento Saídas" like Revenue
--------------------off topic------------
If I don't use external filter the values will be for all table, and I need only revenue
Now, I want to show in another column with the MAXx, the value for the first item and so on, until TOPN
Then I created another measure
In this measure I'm forcing the filter inside the formula intead external filter.
The result is values is corretc, but, when a put the measure on the table, the Dax expand for all products
-----------check value - rank number 1 --------------
What I have to do to not expand the table?
Solved! Go to Solution.
Myself find a way. I Have use an IF on formula.
Myself find a way. I Have use an IF on formula.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
37 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
32 | |
28 | |
24 | |
24 |