Forum Discussion

preetjawaria's avatar
preetjawaria
Frequent Visitor
3 years ago
Solved

Calculating same measure with different filter context

Sample Data:   Acct Name Bill Name Report Count A1 Null 7 A2 Null 12 Null B1 13 Null B2 9 Null B3 3   I have a scenario now - I created 2 slicer - Acct Name & Bil...
Need Help
  • TomMartens's avatar
    TomMartens
    3 years ago

    Hey preetjawaria ,

     

    your requirement can not be solved having only a single table, this due to the concept of Auto-Exist: Understanding DAX Auto-Exist - SQLBI

    My recommendation is to create a proper star schema with separate Dimension Tables Account and Bill, you might also consider creating two fact tables one for BILL and one for ACCOUNT.

    Regards,
    Tom

preetjawaria's avatar
preetjawaria
Frequent Visitor
3 years ago

Hi TomMartens , you understood the scenario correctly, now lets say you select value A1 from first slicer and B2 from the other slicer - then the card visuals will show 7 and 9 respectively.

So the Total Measure should return 16 (7+9) to us.

Am I clear now ?

  • TomMartens's avatar
    TomMartens
    Super User
    3 years ago

    Hey preetjawaria ,

     

    your requirement can not be solved having only a single table, this due to the concept of Auto-Exist: Understanding DAX Auto-Exist - SQLBI

    My recommendation is to create a proper star schema with separate Dimension Tables Account and Bill, you might also consider creating two fact tables one for BILL and one for ACCOUNT.

    Regards,
    Tom