Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I am trying to find away to show the top stores that represnts a combined sales of 10B$ for example
Extra: would be to make this combines sales a whatIf parameter (that user can change from 1 , 2, ...10B)
Thank you in advanceT
Solved! Go to Solution.
Hi,
Share the link from where i can download your PBI file.
Hi,
This screenshot should say it all. I have applied a filter with the criteria of <=3000000000. These are the measures i used
Rank of Stores by total sales = if(HASONEVALUE(Stores[StoreName]),RANKX(ALL(Stores[StoreName]),[Total Sales]),BLANK())
Cumulative sales = SUMX(TOPN([Rank of Stores by total sales],CALCULATETABLE(VALUES(Stores[StoreName]),ALL(Stores[StoreName])),[Total Sales]),[Total Sales])
Hope this helps.
Try this
Measure =
VAR __sales =
ADDCOLUMNS(
ALL( Stores[StoreName] ),
"@sales", [Total Sales]
)
VAR __stors =
SELECTCOLUMNS(
FILTER(
__sales,
SUMX(
FILTER(
SELECTCOLUMNS( __sales, "@@sales", [@sales] ),
[@sales] < [@@sales]
),
[@@sales] ) > MAX( 'selections'[selection] )
),
"StoreName", Stores[StoreName]
)
RETURN
CALCULATE(
[Total Sales],
KEEPFILTERS( NOT Stores[StoreName] IN __stors )
)
Hi,
Share the link from where i can download your PBI file.
Thank you very much. I have put the file in OneDrive (I couldn't load it here idrectly)
https://1drv.ms/u/s!AibcI9O4iXjagYNCJ3-Qrsl1xRYa8A?e=bvBtnU
It is the standard Microsoft Contososales file
Try this
Measure =
VAR __sales =
ADDCOLUMNS(
ALL( Stores[StoreName] ),
"@sales", [Total Sales]
)
VAR __stors =
SELECTCOLUMNS(
FILTER(
__sales,
SUMX(
FILTER(
SELECTCOLUMNS( __sales, "@@sales", [@sales] ),
[@sales] < [@@sales]
),
[@@sales] ) > MAX( 'selections'[selection] )
),
"StoreName", Stores[StoreName]
)
RETURN
CALCULATE(
[Total Sales],
KEEPFILTERS( NOT Stores[StoreName] IN __stors )
)
Hi,
This screenshot should say it all. I have applied a filter with the criteria of <=3000000000. These are the measures i used
Rank of Stores by total sales = if(HASONEVALUE(Stores[StoreName]),RANKX(ALL(Stores[StoreName]),[Total Sales]),BLANK())
Cumulative sales = SUMX(TOPN([Rank of Stores by total sales],CALCULATETABLE(VALUES(Stores[StoreName]),ALL(Stores[StoreName])),[Total Sales]),[Total Sales])
Hope this helps.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |