Forum

Francis Kinsler
@fdkin1
Active Member
Joined: Dec 7, 2020
Topics: 1 / Replies: 4
Reply
RE: Measure for Status of 'Complete' over multiple workbooks

My solution... =CALCULATE( COUNTA( BusinessChange[Id] ...

4 years ago
Forum
Reply
RE: Measure for Status of 'Complete' over multiple workbooks

Ok thanks. As I said in my first post, I have my data organised in PP in a Star schema data model centred around Milestone as the Fact table with a...

4 years ago
Forum
Reply
RE: Measure for Status of 'Complete' over multiple workbooks

Thanks. I get PP ok but was thinking that as I need to be able to use a slicer on the Milestone I'm going to need a table of counts of the Complete st...

4 years ago
Forum
Reply
RE: Measure for Status of 'Complete' over multiple workbooks

Thanks Catalin. Each Dimension table is connected to the Milestone Fact table using a Milestone reference. Each Dimension table has a Status column...

4 years ago
Forum
Topic