atonalwilson Posted March 8, 2023 Share Posted March 8, 2023 I need to apply statistical de-identification rules in an MSBI Tabular model. An example of the kinds of rules I'm trying to implement is: if N < 20,000, then any row less than 11 must be combined with other rows. Example: I report counts of Foo by Dimension Bar. All these issues are discussed in Msbi Course. Since the total (in this ALLSELECTED context) is less than 20K Foo, this output is not valid: Bar 1: 500 Bar 2: 400 Bar 3: 100 Bar 4: 11 Total: 1011 The valid output would be valid: Bar 1: 500 Bar 2: 400 Bar 3 & 4: 111 Total: 1011 I want to use a measure so that when users change from Dimension Bar to Dimension Baz, or when I change the slicers being used, I want these rules to recalculate on the fly - so just combining the rows for that one dimension in the model is not the solution I'm looking for. Thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.