Display information in a matrix as a function of a measurement and a data table

[Anonymous]

Hi,

I'm working on a Power BI report that I want to integrate into a Power Apps application, and I can't seem to display the information I want.
I have two important data tables, CommonControlsEnd and HistoriqueModification. These two tables are linked by a third table called Affaires.

In the matrix I've set up, I've displayed the ‘EtapeModifiee’ and ‘FicheModifiee’ rows, which are in the HistoriqueModification table, and I've set the value ‘MostRecentCheck’, which gives me the status of the ‘FicheModifiee’ according to the filters I've chosen.
I'd like to be able to display information based on the progress of the form afterwards.
To do this, in the CommonControlsEnd table, I have the ‘Title’ column, which corresponds to the ‘FicheModifiee’ column, and in this table, I have the ‘Approuve’ column.
I'd like to have a new column in my table so that if ‘MostRecentCheck’ returns ‘false’, then nothing is displayed. If ‘MostRecentCheck’ returns ‘true’, it looks to see if there's any data in the ‘CommonControlsEnd’ table with the row name as the Title, if there isn't, it returns ‘Nothing’, if there is data, it looks at the status of the ‘Approuve’ column, if it's true, it returns ‘Verified’, otherwise it returns ‘To verify’.

Thank you in advance for your help !

[Anonymous]

Hi, @Anonymous 

You can try use Flag measure, and put the Flag measure into Filter Pane for filtering. Feel free to help you if you can share the test pbix file without sensitive data.

Best Regards,
Yang
Community Support Team

[Anonymous · Accepted solution]

Hi @Anonymous,

Sorry, I haven't worked since Friday.
I solved my problem at the end of the day on Thursday with this measure : 

FicheStatusMeasure =

VAR Fiche = SELECTEDVALUE('HistoriqueModification'[FicheModifiee])

VAR FicheExiste =

    COUNTROWS(

        FILTER(

            'CommonControlsEnd',

            'CommonControlsEnd'[Title] = Fiche

        )

    ) > 0

VAR NombreApprouveTrue =

    CALCULATE(

        COUNTROWS('CommonControlsEnd'),

        'CommonControlsEnd'[Title] = Fiche,

        'CommonControlsEnd'[Approuve] = TRUE

    )

VAR NombreApprouveFalse =

    CALCULATE(

        COUNTROWS('CommonControlsEnd'),

        'CommonControlsEnd'[Title] = Fiche,

        'CommonControlsEnd'[Approuve] = FALSE

    )

RETURN

IF(

    NOT FicheExiste,

    "",

    IF(

        NombreApprouveTrue = NombreApprouveFalse,

        "Vérifiée",

        "Rédigée"

    )

)

This measure doesn't do exactly what I'd originally asked for, but I've modified it so that it shows what I'm really interested in. My initial request was simpler than this one, in particular because I hadn't specified that several records could be written or checked for the same name.
Have a nice day!