Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Total Sales

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:

CountryStateSales
USLA

1512

IndiaMH1515
USDC1548
IndiaAP4123

 

Output:

CountryTotal SalesSPI %
India86985638/8698
US86983060/8698

 

Thanks in advance

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Anonymous 

    Doesn't the following work?

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

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amitchandak ,

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous 

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

        Thanks,
        Nirav

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    Anonymous 

    Doesn't the following work?

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