DAX - combine (not calculate) two different columns based on date

[Anonymous]

I have some migration data:

UserMigration

Key | IsMigrated | PlannedMigrationDate

I also have a date table that is related to PlannedMigrationDate.

I have PlannedMigrationDate as a Boolean calculated column so I can count the number of migrations that was supposed to happen that day.

Can I create a measure that would count the IsMigrated, and the PlannedMigrations by day?

So it would look like this so I could join it do a day in my Date "dimension":

MigrationStatus

24 / 26

[waltheed · Accepted solution]

Hi Jasel,

Yes, sounds like you are almost there...

If you create measures that just count the rows in your table, like

Count of Migrations:= COUNTROWS('UserMigration')

and

Count of IsMigrated:= CALCULATE(COUNTROWS('UserMigration'), FILTER(IsMigrated = 1))

Then you can use these measures in a pivot table and show them by attributes of your Date Table like month, day, week, etc.

[Anonymous]

That did it sir.  Thank you very much for the help!

Now to find time to learn some intermediate DAX...