Forum Discussion

netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
4 years ago

Different filters on the same visual

Hey All!   I have a table where each column should be filtered differently For example column A will get the following filter: working, Forecast, 5 sites column B will get the following filte...
Need Help
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

netanel 

Since you are trying filter on the same table but different columns, the records that get satisfied by filter will be returned. Please check the example below:

CALCULATETABLE (
    'Product',
    'Product'[Color] IN {"Blue","Purple"},
    'Product'[Brand] IN {"Contoso","Fabricam"}
)



  • netanel's avatar
    netanel
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Hey Fowmy 

     

    Calculatetable is Good butt Product is DIM 1
    I have more Diminsion

    Is it possible to make another DIM on the same Measure?

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      4 years ago

      netanel 

      Sorry, could you expalin with some data along with the expected results to better understand your question ?


      • netanel's avatar
        netanel
        Icon for Post Prodigy rankPost Prodigy
        4 years ago

        Fowmy 


        Yes, sorry it really is not understood enough
        Attach a picture that will explain more
        In the picture I have a table of PNL
        The table has two columns
        In each column I have different filters from a different DIM
        So if product is DIM 1 then I have more filters from DIM 2 and DIM 3
        Link to file: https://1drv.ms/f/s!AonyYI-TdspHgltwngZ6OKvpnSsc