Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure for Minimum n/sample size

Hi all, I have a tricky issue: how best to suppress low sample sizes which can be inferred from the present of other data? For example, when a male N is 2, and the total of staff is 9, then even when...
Data Protection
Need Help
Tutorial Requests
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    Does that meet your requirement?

    Measure = 
VAR a =
    MINX (
        ALL ( WORKER_AVG_HC[EEID] ),
        CALCULATE ( COUNTX ( WORKER_AVG_HC, WORKER_AVG_HC[EEID] ) )
    )
VAR b =
    COUNTX ( WORKER_AVG_HC, WORKER_AVG_HC[EEID] )
RETURN
    IF ( a = b, "***", b )

     

    Pbix as attached. If it doesn't meet your requirement,  kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

     

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Anonymous ,

 

Does that meet your requirement?

Measure = 
VAR a =
    MINX (
        ALL ( WORKER_AVG_HC[EEID] ),
        CALCULATE ( COUNTX ( WORKER_AVG_HC, WORKER_AVG_HC[EEID] ) )
    )
VAR b =
    COUNTX ( WORKER_AVG_HC, WORKER_AVG_HC[EEID] )
RETURN
    IF ( a = b, "***", b )

 

Pbix as attached. If it doesn't meet your requirement,  kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.