Total Sales

[Anonymous]

Hi all,

Is there a way to create total sales and SPI% measure irrespective of the filters selection.It would be great if it is done in dax because I want to use the same measure for further calculations.

Data:

Country	State	Sales
US	LA	1512
India	MH	1515
US	DC	1548
India	AP	4123

Output:

Country	Total Sales	SPI %
India	8698	5638/8698
US	8698	3060/8698

Thanks in advance

[PaulDBrown · Accepted solution]

@Anonymous 

Doesn't the following work?

No filters = CALCULATE([Sum Measure], ALL(Fact Table))

[amitchandak]

@Anonymous ,

Try like

calculate(Sum(Table[Sales]), all(Table))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Hi @amitchandak ,

I have just updated the requirement can you please check this?

[Anonymous]

Hi @Anonymous 

Create measures as
Total Sales = calculate(Sum(Table[Sales]), all(Table))
&
SPI % = Devide('Table' [Sales], Sum( 'Table'[Sales]))

Thanks,
Nirav