Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Print Status

Hi All,

I want to print my staus in a measure.

Please help.

Instead of count I want to print the status.

 

3 Replies

  • nandic's avatar
    nandic
    Resident Rockstar

    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's avatar
      Anonymous
      Not applicable

      This is the the status I am looking for

       

  • Anonymous's avatar
    Anonymous
    Not applicable

    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