Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Power BI drill through

I have report like this : 

 

 

and when i click on drill through i see this : 

 

 

And this filter my results upon Sifra artikla. But on Broj fakture i have multiple Sifra artikla codes. 

I want to see all Sifra artikla codes on this Broj fakture because Broj fakure containts more Sifra artikla...

On drill through i want to set filter to Broj fakture but i want to see all Sifra artikla. 


How i can do this?

Actually i want to remove filter from Sifra artikla but keep filter for Broj fakture

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

    You can refer to the following solution.

    Sample data 

    1.Create a table

    Table 2 = SUMMARIZE('Table',[Sifra artikla])

    2.Then create a relationship between tables.

     

    3.Create a measure

    MEASURE =
VAR a =
    CALCULATETABLE (
        VALUES ( 'Table'[Broj fakture] ),
        'Table'[Sifra artikla] IN VALUES ( 'Table 2'[Sifra artikla] ),
        CROSSFILTER ( 'Table 2'[Sifra artikla], 'Table'[Sifra artikla], NONE )
    )
RETURN
    CALCULATE (
        COUNTROWS ( 'Table' ),
        'Table'[Broj fakture] IN a,
        CROSSFILTER ( 'Table 2'[Sifra artikla], 'Table'[Sifra artikla], NONE )
    )

    4.Then in the first page put the Sifra artikla field of table2, in the second page put the measure and the Broj fakture , Sifra artika  of original table the table visual.

    5.Put the Sifra artikla field of table2 to the drill through filter at the second page

     

    Output:

    select 100 at the first page

     

    Then drill through.

    Best Regards!

    Yolo Zhu

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

     

     

     

     

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    Anonymous , On the drill through page disable - Keep all filters and then Add all columns you want to pass the values in Drill through from. Do not keep the one you do not want to pass

     

     

     

    Power BI Drill Through - More than one level: https://www.youtube.com/watch?v=hCAAvpppQmk

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      No, this is not what i want. 

       

      You can see my first image, that I have Sifra artika 5892332100 and i have Sifra artika on two Broj fakture.



      But my Broj fakture have multiple Sifra artika, you can see on this image : 

       

      When i click to drill through on my Sifra artkla,  I want to eliminate filter from Sifra artikla but keep filter for Broj fakture  to show me other Sifra artikla what have on this two Broj fakture. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous 

        You can refer to the following solution.

        Sample data 

        1.Create a table

        Table 2 = SUMMARIZE('Table',[Sifra artikla])

        2.Then create a relationship between tables.

         

        3.Create a measure

        MEASURE =
VAR a =
    CALCULATETABLE (
        VALUES ( 'Table'[Broj fakture] ),
        'Table'[Sifra artikla] IN VALUES ( 'Table 2'[Sifra artikla] ),
        CROSSFILTER ( 'Table 2'[Sifra artikla], 'Table'[Sifra artikla], NONE )
    )
RETURN
    CALCULATE (
        COUNTROWS ( 'Table' ),
        'Table'[Broj fakture] IN a,
        CROSSFILTER ( 'Table 2'[Sifra artikla], 'Table'[Sifra artikla], NONE )
    )

        4.Then in the first page put the Sifra artikla field of table2, in the second page put the measure and the Broj fakture , Sifra artika  of original table the table visual.

        5.Put the Sifra artikla field of table2 to the drill through filter at the second page

         

        Output:

        select 100 at the first page

         

        Then drill through.

        Best Regards!

        Yolo Zhu

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