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 c...
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.

     

     

     

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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.