Forum Discussion

Frequent Visitor

9 years ago

Solved

What's the difference between ALL vs. ALLSELECTED, with formula filter as table vs. column

The original file Understanding Your Customers is downloaded from http://enterprisedna.co/power-bi-resources. When calculating the total sales with different filters ALL and ALLSELECTED, with for...

Anonymous

Not applicable

9 years ago

Can you provide the pbix file to test? I'm not very clear for your measure "Total Sales".

Regards,

Xiaoxin Sheng

lilyyan
Frequent Visitor
9 years ago
AnonymousSorry that I don't know how to attach the file here. It's downloaded as mentioned in post: Understanding Your Customers from http://enterprisedna.co/power-bi-resources.

The source data file as below, including one row named Total Revenue. And Total Sales = SUM(Sales[Total Revenue])
:
- lilyyan
  Frequent Visitor
  9 years ago
  Anonymouspls refer to the pbxi file here
  - Anonymous
    Not applicable
    9 years ago
    Hi lilyyan,
    
    I think I found the reason, please take a look at below test steps.
    
    Measure used to display the current row count.
    
    All(Table)/All(Column)/AllSelected(Table)/Allselected(Column) = COUNTROWS(ALL(Dates))&"-"&COUNTROWS(ALL(Dates[Date]))&"-"&COUNTROWS(ALLSELECTED(Dates))&"-"&COUNTROWS(ALLSELECTED(Dates[Date]))
    
    1. Calculate the real count by year filter and quarter filter.
    
    Result: allselected table work, allselected column not work.
    
    2. Test with date slicer.
    
    Result: allselected(table) and allselected(column) works.
    
    3. Test with date slicer and line chart.
    
    In summary, when you use allselected function, you should remember allselected(table) can works on all of its columns, but allselected(column) only works on the slicer with specify column as the source.
    
    Regards,
    
    Xiaoxin Sheng

Related content