Forum Discussion

Anonymous

Not applicable

4 years ago

SUM rows filtered by data segmentation

Hello everyone, I'm trying to SUM a column called "Offline Time". This column has 300 rows. But I don't want to SUM all these rows, I want to SUM using data segmentation as a parameter. For example...

DAX

Desktop

Power BI Desktop

Anonymous

Not applicable

4 years ago

Thanks for the answer 😉

But I believe that the key is to sum the column with some condition.
I'm trying something like that:

SUM Offline time = CALCULATE(SUMX(Offline, Offline[Offline time(minutes)]), ALLSELECTED(Offline[Alert Date]))

I'm not sure if I should use ALLSELECTED. What I intend to do is to sum the Offline Time(minutes) using the offline as a parameter. Notice that in data segmentation I'm using Calendar Offline[Date] instead of Offline[Alert Date]

Whitewater100

Solution Sage

4 years ago

Hi:

If I can see the data (some data with exepcted result) I can try to answer more thoruoghly.

The way yo have your data model and the visual you are attempting to create pretty much drives the DAX solution.

Thanks!

Anonymous
Not applicable
4 years ago
Table Offline Calendar:

Offline table:

Data Segmentation using Offline Calendar:

Now I need to sum these three offline time rows (Tempo Offline(min))

Thanks in advance 🙂
- Icey
  Community Support
  4 years ago
  Hi Anonymous ,
  
  Do you create relationship between your two tables? If you have created it, no other action is needed. The measure result will change dynamically based on your date slicer, which called "visual interactions".
  
  For more details about relationship, please check:
  
  Model relationships in Power BI Desktop - Power BI | Microsoft Docs
  
  Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs
  
  For more details about visual interactions, please check:
  
  Slicers in Power BI - Power BI | Microsoft Docs
  
  Change how visuals interact in a report - Power BI | Microsoft Docs
  
  Understand how visuals interact in a report - Power BI | Microsoft Docs
  
  Filters and highlighting in Power BI reports - Power BI | Microsoft Docs
  
  Best Regards,
  
  Icey
  
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  - Anonymous
    Not applicable
    4 years ago
    Hello,
    after your tip, I did the relationship between these two tables. But it does not help at all.

Forum Discussion

SUM rows filtered by data segmentation

Related content

filter with segmentation

Calculate Based on Filtered Segment

Filter rows

Filter on Visual Row Context

Segmentation can filter another segmentation