Forum Discussion

Anonymous's avatar
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
Whitewater100's avatar
Whitewater100
Solution Sage
4 years ago

Hi:

In your date table, please mark column date as Date Table.  Then add calc columns to date table.

WEEK No. = WEEKNUM(DateTableName[Date])

YEAR = YEAR(DateTableName[Date])

Month No. = MONTH(DateTableName[Date])

Connect your date table date filed to your facttable date column, to create a relationship.

Stay with original measure Total = SUM(Table[offlinetime])

Add slicer taking week no field from date table. picture below.

Use slicer to get the the values you want for sum of offlinetime.

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello,

thanks for your tip.

However, I  can not use the week as a slicer. I need to use the complete date. And the full date is not working as well. 😕

  • Whitewater100's avatar
    Whitewater100
    Solution Sage
    4 years ago

    Hi:

    That doesn't make too much sense to me as I can't see your model. Can you supply this file for a more complete answer?

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Of course not. This file is for my organization. lol

      I'm not studying. I'm working.