Print Status

[Anonymous]

Hi All,

I want to print my staus in a measure.

Please help.

Instead of count I want to print the status.

[v-eqin-msft]

Hi @Anonymous ,

Just use the formula as follows:

Measure =
CALCULATE (
    MIN ( 'COMPLIANCE_DB'[Status] ),
    FILTER (
        'COMPLIANCE_DB',
        'COMPLIANCE_DB'[Practice] = "Data"
            || 'COMPLIANCE_DB'[Compliance Requirement] = "HIPAA"
                && 'COMPLIANCE_DB'[Index] = MIN ( 'COMPLIANCE_DB'[Index] )
    )
)

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[nandic]

@Anonymous ,
Is current formula still needed or you are interested to only display the status value?
Calculate function returns one value, and mainly it is used to return numeric (aggregated) values - as you did it.
Also, you can return text values if you use function like FirstNonBlank (column).
If you display new measure and column for status in a list, it will display count per each status.
Could you send image what is expected output?

[Anonymous]

This is the the status I am looking for