Forum Discussion

ignas's avatar
ignas
Advocate II
7 years ago
Solved

Data model question

  Hello   I would like to hear your best practise dealing with such data model.     I have dimCustomer table which connects fact_open and fact tables.   I want to show in the report onl...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    ignas,

    You can create a column in dimcustomer table using DAX below. Then drag the column to page level filter and set its value to "Not blank".

    checkColumn = COUNTROWS(RELATEDTABLE(fact_open))



    Regards,
    Lydia

affan's avatar
affan
Solution Sage
7 years ago

Hi ignas

 

You can acheive to display only the non blank by using the visual filter, without any complex options

 

 

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan

 

 

 

  • ignas's avatar
    ignas
    Advocate II
    7 years ago

    Hello affan

     

    Unfortunatelly this does not do any changes to the filter.

    I need to see in the filter only those customers that have no amount in fact_open.

     

    Any thoughts?

     

    Regards,

     

    Ignas 

    • affan's avatar
      affan
      Solution Sage
      7 years ago

      ignas

       

      As filtering the slicer is not directly available as of now. However you can use the workarround used in the below illustration to acheive the result.

      slicer filter

       

       

      If this helped you, please mark this post as an accepted solution and like to give KUDOS .

       

      Regards,

      Affan

       

      • ignas's avatar
        ignas
        Advocate II
        7 years ago

        I cannot change from single to both, because I will have data model issues with other dimensions. For example if I have customer both relationship then what I can do if I need to use data filter? Data filter again will show all possible dates.

         

        It must be another solution related with structuring data model in another way.


        Regards,

         

        Ignas