venug20 Tracker

Re: Display state wise sales - exclude slicer selection

venug20 — Tue, 23 Oct 2018 09:14:42 GMT

Hi Xiaoxin Sheng / Anonymous,

Thanks for your explanation, now i understood...

Re: Display state wise sales - exclude slicer selection

venug20 — Tue, 23 Oct 2018 08:17:32 GMT

Thanks Anonymous it is working fine...

Thanks PattemManohar. you suggestion is perfect...

Anonymous

Can you explain step by step, how it's working...

Re: Display state wise sales - exclude slicer selection

venug20 — Tue, 23 Oct 2018 07:36:29 GMT

Hi Anonymous / Xiaoxin Sheng,

Thank you very much for your reply. It's really great work. I am really apriciate your efforts.

Please let me explain, what i am expecting output. Please see below snapshots...

When i take "State" wise sales into visual, it show like below... (Total is : 1,37,15,444.31)

when i exclude state as "Abia" using basic filter (Visual level), it show like below... (Total is : 1,37,14,380.19)

You provided file shown state wise sales, when i exclude state as "Abia" from slicer. it show like below... (Total is : 9,08,620.78)

here some state sales are missing, your approch is 100% correct.

but State wise sales total giving wrong. Please suggest to is there any way to get correct output....

Please help on this requirement.....

Once again thank you for your reply....

Re: I want to display last 5 years sales when i select one year

venug20 — Tue, 23 Oct 2018 06:46:55 GMT

v-danhe-msft

Thanks for your solution, great work. which i has been expected, got the same solution from you.

Display state wise sales - exclude slicer selection

venug20 — Mon, 22 Oct 2018 15:32:38 GMT

Hi everyone,

I have one table.

I want to display "sales", based on Slicer selection.

I have taken "State" into slicer. When choose state in slicer, show all state wise sales, except slicer selection.

Please help on this.... Thanks in Advance.....

Re: I want to display last 5 years sales when i select one year

venug20 — Mon, 22 Oct 2018 03:44:26 GMT

Ashish_Mathur

There is no "Year"(Slicer) selection option. If possible, Please help on this issue...

Thanks in advance...

Re: I want to display last 5 years sales when i select one year

venug20 — Sun, 21 Oct 2018 12:39:01 GMT

Ashish_Mathur

Thank you for your effort.

i have done which is giving steps in above. i got output like below.....

If not happend selection from slicer. output come like this...

when i select "2017" from slicer. the output should come like "2017, 2016, 2015, 2014, 2013" with respective years sales values.

should not show total sales values to respective years..

I want to display last 5 years sales when i select one year

venug20 — Sun, 21 Oct 2018 06:58:47 GMT

Hi every one,

i have a table. i want to show data like "Order date (Years)", "Sales". i have given one slicer for years, when i select year from slicer. i want to display last 5 years slaes.

How can i achive this.... Please help on this...

Thanks in advance.....

Re: Dax Measure with related Table

venug20 — Sun, 21 Oct 2018 06:52:23 GMT

ChandeepChhabra

superb... solution... very good smart effort.... thanks for reply...

Re: Dax Measure with related Table

venug20 — Sat, 20 Oct 2018 07:05:32 GMT

coolshib

I am trying to display same column calculation field (Online, offline). till not achieve..

you can try inthe mean while, i will provide dax formula which i has got upto till now....

Online Sales = CALCULATE(SUM('Product'[Sales.Quantity]) * SUM('Product-Price'[Online Price]), FILTER('Product', 'Product'[Category] = RELATED('Product-Price'[Category]) && 'Product'[Sales.Mode] = "Online"))

Offline Sales = CALCULATE(SUM('Product'[Sales.Quantity]) * SUM('Product-Price'[Offline Price]), FILTER('Product', 'Product'[Category] = RELATED('Product-Price'[Category]) && 'Product'[Sales.Mode] = "Offline"))

Re: Dax Measure with related Table

venug20 — Fri, 19 Oct 2018 15:22:15 GMT

coolshib

Is it ok with the below output...

Re: Bill of Material Totals

venug20 — Wed, 17 Oct 2018 06:06:06 GMT

hk2018086

can you explain one more time... if possible...

i have modified your data, as per below table.. how come your result...

Level	Part	qty
1	A	1
2	B	5
3	C	3
4	D	2
2	E	3
3	F	3
3	D	5
2	C	2
1	B	2

Re: Display TOP N by Count base on 1 Field

venug20 — Mon, 15 Oct 2018 11:23:18 GMT

cst_dev32

You can achive this in two ways

1st way: which already provide in above...

1. go to menu bar select "Edit Queries"

2. go add column "index column"

3. select "From 1" in index column

like below

2nd way: (If not available power query editor)

1. create one column for count

index = CALCULATE(COUNT('Rank'[Plant]), FILTER('Rank', 'Rank'[Plant] = EARLIER('Rank'[Plant])))

2. create quick measure for running total

index running total in Plant =
CALCULATE(
SUM('Rank'[index]),
FILTER(
ALLSELECTED('Rank'[Plant]),
ISONORAFTER('Rank'[Plant], MAX('Rank'[Plant]), DESC)
)
)

3. take "index running total in Plant" into visual filter chose <6

if it is solution for your query, please accept as solution...

Re: Display TOP N by Count base on 1 Field

venug20 — Mon, 15 Oct 2018 06:59:49 GMT

cst_dev32

you can achive by this way... it may helps... you can try....

Steps:

1. create index column

2. take index column into visual filter

3. you can choose your number in filter... then apply

If it is solution to your query. Please accept as a soluiton... it will helps to others....

Re: Top 10 Values with Running Total

venug20 — Mon, 15 Oct 2018 05:02:14 GMT

parry2k

Thanks you very much, ultimate effort....

Re: running month sales compare with last month same period

venug20 — Sun, 14 Oct 2018 12:24:30 GMT

Ashish_Mathur

Thanks for your support. great work...

Re: Top 10 Values with Running Total

venug20 — Sun, 14 Oct 2018 11:22:02 GMT

Hi everyone,

Anyone help on this.... Thanks in advance....

Re: running month sales compare with last month same period

venug20 — Sat, 13 Oct 2018 16:31:44 GMT

LivioLanzo

provided formula work for only "MTD" and "LMTD". your formula come output like below..

You did not understand, what i am asking......

Actually Last month sales total until ("12/09/2018") : 74133960

but your formula showing Last month sales : 244756978

Re: running month sales compare with last month same period

venug20 — Sat, 13 Oct 2018 15:51:31 GMT

LivioLanzo

Yes, but last month date should be consider with current month max date.

Ex: current month date is : 12/10/2018

previous month date should be consider until : 12/09/2018

running month sales compare with last month same period

venug20 — Sat, 13 Oct 2018 14:09:29 GMT

Hi Everyone,

I want to compare Running month sales with Last month same date sales....

i have sample data like below....

Date	Sales
01-08-2018	774019
01-08-2018	2864614
02-08-2018	4327149
04-08-2018	9484063
04-08-2018	552646
05-08-2018	7200047
06-08-2018	4127748
07-08-2018	7771021
07-08-2018	9555981
09-08-2018	1670632
11-08-2018	2204685
12-08-2018	8624325
14-08-2018	1592451
18-08-2018	7456219
19-08-2018	4843082
19-08-2018	4677379
19-08-2018	7754521
20-08-2018	3553001
21-08-2018	2379353
22-08-2018	2535366
23-08-2018	100711
24-08-2018	7773585
25-08-2018	4077178
25-08-2018	2701314
25-08-2018	1806145
27-08-2018	5094423
27-08-2018	6451069
27-08-2018	6563320
30-08-2018	3839747
30-08-2018	7915591
01-09-2018	3626036
01-09-2018	5135758
02-09-2018	101864
03-09-2018	1837458
03-09-2018	969222
04-09-2018	6301839
04-09-2018	8092501
05-09-2018	1540884
05-09-2018	4032377
05-09-2018	5600601
05-09-2018	7477302
09-09-2018	4589098
10-09-2018	1861708
11-09-2018	9645637
11-09-2018	9738372
12-09-2018	2254119
12-09-2018	1329184
13-09-2018	461376
14-09-2018	5856587
14-09-2018	3468020
15-09-2018	3441323
15-09-2018	6603088
16-09-2018	6010656
17-09-2018	9962512
18-09-2018	8084655
18-09-2018	8753408
18-09-2018	482237
18-09-2018	9107761
18-09-2018	7233343
18-09-2018	6753841
20-09-2018	4119016
21-09-2018	1485646
21-09-2018	6544544
22-09-2018	8564538
22-09-2018	9317119
24-09-2018	6805925
25-09-2018	3236492
26-09-2018	5877239
26-09-2018	8783711
26-09-2018	8789064
27-09-2018	8792481
27-09-2018	4212358
27-09-2018	2434400
27-09-2018	7512500
28-09-2018	2738976
29-09-2018	4241380
29-09-2018	264569
30-09-2018	684253
02-10-2018	7709811
02-10-2018	9395141
03-10-2018	3813815
03-10-2018	5887664
04-10-2018	2855439
04-10-2018	9972596
05-10-2018	4535466
05-10-2018	7471509
06-10-2018	8039808
07-10-2018	688833
08-10-2018	2056621
09-10-2018	6925643
09-10-2018	6771175
09-10-2018	6373270
10-10-2018	5189761
10-10-2018	9878230
10-10-2018	5729479
11-10-2018	4831859
12-10-2018	1621092
12-10-2018	99061
12-10-2018	5275012
12-10-2018	7347056

How i can achive this.... Thanks in Advance....