Evolution of two different measurements according to the filter of a user

[DALI007]

Hello to all,

I try to follow the evolution of two different measures (taux de completude Linky et nombre de site total) according to the filter chosen by the user. (the filter is a parameter that I set up. Each parameter corresponds to a different column of the table). for information the constructor, Zones, No of band OC three columns of my tables.

=>

I can track the measure  "Nombre de site total" by category. But regarding the completion rate Linky, I can only show the total, but not the completeness rate of each category.
You have a solution to be able to display the linky completeness rate of each category in curve in the same graph, please..  

Thank you in advance for your help

[DALI007]

Hello @Anonymous,

Thank you for your answer. This example works when the visualization dimension (a parameter I created) concerns the different values of a single column. In my case, in the view dimensions, I have different columns. Here is my parameter created:

The measures:

Taux de complétude Linky = (DIVIDE([Nbre site consomme] , [nb sites total]))

Nbre site consomme = COUNTROWS(FILTER('NRJ_TRAFIC_PUISSANCE_MOIS','NRJ_TRAFIC_PUISSANCE_MOIS'[P_MOY_W] <> 0))

nb sites total = COUNTROWS(NRJ_TRAFIC_PUISSANCE_MOIS)

I tried to create a measure to display the rate of [Linky completion rate ] for each type of category chosen but it did not solve the problem. (I took only one example category:  : Constructeur.

Taux de completude par dimension =

VAR dimensionSelectionnee = SELECTEDVALUE('Dimension de visualisation 2'[Categorie])

RETURN

SWITCH(

    TRUE(),

    dimensionSelectionnee = "Constructeur",

        SWITCH(

            TRUE(),

            SELECTEDVALUE(NRJ_TRAFIC_PUISSANCE_MOIS[CONSTRUCTEUR_PRINCIPAL]) = "ERICSSON", [Taux de complétude Linky ericson],

            SELECTEDVALUE(NRJ_TRAFIC_PUISSANCE_MOIS[CONSTRUCTEUR_PRINCIPAL]) = "HUAWEI", [Taux de complétude Linky huawei],

            SELECTEDVALUE(NRJ_TRAFIC_PUISSANCE_MOIS[CONSTRUCTEUR_PRINCIPAL]) = "AUTRE", [Taux de complétude Linky autre]

        ),     

    BLANK()

)

My Model :

My Visual

Thanks for your help

Regards

[Anonymous · Accepted solution]

Hi  @DALI007 ,

I created some data:

You can start by finding the TOTAL, and after finding the VALUE for each category, use the divide() function to come up with the completion rate for each category.

Create measure

category_completeness rate =
var _totalvalue=SUMX(ALL('Table'),[Value])
var _categoryvalue=SUMX('Table',[Value])
return
DIVIDE(
    _categoryvalue,_totalvalue)

Because the red box “Taux de completude Linky” belongs to Line y-axis, and Column y-axis belongs to two kinds of display, you need to create a measure for Line y-axis with the same function as the above to display it.

If the results above don't meet your expectations, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly