Forum Discussion

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 

Create 'Specific Rows' Table or import it from it from excel. Then create a measure 

Filter Measure =
COUNTROWS ( FILTER ( Finance, Finance[Line Description] IN 'Specific Rows'[ Specific Rows]) )
Place this measure in the filter pane of the table visual and select "Is not blank" and apply the filter. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    tamerj1  Please read my post. I want Budget/Actual. but, I want the % to be on specific row.. which i posted. They are other row but, i want % to be on specific row while other rows remain the same.

    Here are the specific i wanted the % on. 

    Baked Goods Gross Margin (31290)                           % 
    Baked Goods Gross Margin (31290)                          %
    Cold Disp Beverage Gross Margin (31294)                %
    Cold Grab & Go Gross Margin (37969)                       %
    Frozen Disp Beverage Gross Margin (31295)             %
    FS Prep on Site Gross Margin (31293)
    Hot Disp Beverage Gross Margin (31296)
    Hot Foods Gross Margin (37968)
    Other Food Service Gross Margin (31292)
    Other Retail Food Service Gross Margin (37970)
    QSR Gross Margin (31297)
    Baked Goods Gross Margin (31290)
    Baked Goods Gross Margin (31290)
    Cold Disp Beverage Gross Margin (31294)
    Cold Grab & Go Gross Margin (37969)
    Frozen Disp Beverage Gross Margin (31295)
    FS Prep on Site Gross Margin (31293)
    Hot Disp Beverage Gross Margin (31296)
    Hot Foods Gross Margin (37968)
    Other Food Service Gross Margin (31292)
    Other Retail Food Service Gross Margin (37970)
    QSR Gross Margin (31297)

    Roller Grill Gross Margin (31291)

     

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Anonymous 

    Some like this

    IF (

    ISEMPTY (FILTER ( Finance, Finance[Line Description] IN 'Specific Rows'[ Specific Rows]) ),

    "",

    [measure]
    )

    however, you might recieve error

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      tamerj1 Thanks, i will try it. But, i tried something like below it won't display anything .


       

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        Anonymous 

        I'm a little lost here. Do you want to show the value for the other rows as blanks or you want to entirely hide the row? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      tamerj1  The Specific rows is part of the Line Description. Line Desc is the column name.

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

         

        Yes. You should have them in a separate single column table. Of course you should use the real name of this column and its table. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      tamerj1  Your DAX works, But, i want the % to display only on the listed row not on other rows. right now it still display on other rows. 

       

       

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        Hi Anonymous 

        then use

        IF (

        ISEMPTY (FILTER ( Finance, Finance[Line Description] IN 'Specific Rows'[ Specific Rows]) ),

        [measure],

        ""
        )

        however, you might recieve error