Forum Discussion

KevinSV's avatar
KevinSV
Icon for Helper II rankHelper II
1 year ago
Solved

Filtrer in one line

Hello everyone,  I need your help on my Power BI Desktop.  First of all, i import my data from a SQL Server for my report. I put some slicers for filter and give a table after the filtrer.  In thi...
Need Help
  • KevinSV's avatar
    KevinSV
    1 year ago

    Here is the update of the topic : 
    So i modify my code : 

    CombinedTable2 =

    UNION(

    SELECTCOLUMNS(

        SUMMARIZE(

            FILTER(ALL('PCA'); 'PCA'[IsAggregateRow] = 1);

            'PCA'[SOCIETE]; PCA[CJOURNAL]; PCA[DTECRIT]; PCA[ANALYT]; --here is the modify i add all the column i need on this line of the code

            "TCOMPTE"; "48700000";

            "MDEBITS"; [Total_MDEBITS];

            "DCREDITS"; [Total_DCREDITS];

            "TLIB"; SELECTEDVALUE(PCA[LIB2])

        );

    "CJOURNAL"; PCA[CJOURNAL];

    "TCOMPTE"; "48700000";

    "CSOC";'PCA'[SOCIETE];

    "MDEBITS"; [Total_MDEBITS];

    "DCREDITS"; [Total_DCREDITS];

    "DECRIT"; PCA[DTECRIT];

    "CANALYT3"; 'PCA'[ANALYT];

    "TLIB"; SELECTEDVALUE(PCA[LIB2])

    );

    SELECTCOLUMNS(

        FILTER(ALL('PCA'); LEFT('PCA'[TCOMPTE]; 1) = "7");

        "CJOURNAL"; 'PCA'[CJOURNAL];

        "TCOMPTE"; 'PCA'[TCOMPTE];

        "CSOC"; 'PCA'[SOCIETE];

        "MDEBITS"; 'PCA'[DEBITS];

        "DCREDITS"; 'PCA'[CREDITS];

        "DECRIT"; 'PCA'[DTECRIT];

        "CANALYT3"; 'PCA'[ANALYT];

        "TLIB"; 'PCA'[LIB2]

    ))


     


    Thanks again  for your helping ! 

KevinSV's avatar
KevinSV
Icon for Helper II rankHelper II
1 year ago

Hello  , thanks for your helping. 
All the measure works as well but when i create my table and try to have a visualisation, i don't have the same amount in the debits and credits when i filter. And that is because it looks like i have juste the TCOMPTE begining with the '7' but delete all the TCOMPTE which not begin with a '7'. But i want them but in one line only : 

 

on my last screen, i don't want to delete them but have all the amount in only one line where the TCompte will have the value '48700000'.
What i have now : 

 

as you can see the total amount are not the same. When i compare with my sql dataset,  it si normal because i don't select the other Tcompte number (where the Tcompte begins with another number than '7'). But when i select them, it rebalances the amount. 
And sorry to add another condition, but i need to put the new '48700000' TCOMPTE number which will create in the first line of the table (is that possible ?).
Thanks again for your helping !