Forum Discussion

bergen288's avatar
bergen288
Helper IV
3 years ago
Solved

Incorrect Data model

I am puzzled with my incorrect data model and any help is really appreciated.  In the screenshot below, PBI_XZ_Case_Time_Session is my fact table and PBI_XZ_Case_Fiserv is my dimentional table whose ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Does this measure work

    =SUMX(Calendar,[Session shours])

bergen288's avatar
bergen288
Helper IV
3 years ago

Sorry, I made a mistake to say SUMX function worked.  I don't want to cause any confusion here.  SUMX function has the same issue with SUM function.  My workaround is to define 2 different measures with and without IF function and use them accordingly.