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

TomMartens's avatar
TomMartens
Super User
3 years ago

Hey preetjawaria ,

 

I'm not 100% clear about the expected result.
From my understanding there are currently two card viusals that are only affected by their corresponding slicers (configured by edit interaction).
My assumption is that these two slicers do not affect each other as well. Is this assumption correct.

What is the expected result for the Total Measure if nothing is selected from both card visuals, meaning both card visuals are showing the value 44 as in the in the screenshot below:

Can you please describe why you can't use a simple measure like the one below for calculating the measure Total Measure:

Total Measure = SUM( 'your table name'[report count] )

 

Regards,
Tom