Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
3 years ago

Creating Measures over flags in Junk Dimension (Design Question)

My data consists of flags rather than metrics and instead of adding them into the fact table I have added them into a junk dimension as per modelling guidance.    I have a fact tables that are go...
Need Help
DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
3 years ago

I think I have it

 

on track = CALCULATE(COUNT('Fact '[JunkKey]),'Dim Junk'[OntrackFlag]=TRUE()|| 'Dim Junk'[Reporting Group Description] = "Metrics")