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 only those customers that have "amount" from "fact_open table". That mean the filter should only show only those names that have amount non blank:

 

 

What would be the best practise?

How can I achieve the result?

 

The file:

https://mega.nz/#!j3IC2KyY!MffHMC37adgpYklv2lFYmJ1iFBlHVG0F3T_95dBXl2c

 

 

Regards,

 

Ignas

 

 

 

a

 

 

 

 

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

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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

    • ignas's avatar
      ignas
      Advocate II
      7 years ago

      Hey Anonymous

       

      You are absolutely amazing. Such a simple solution solves my big problems.

       

      Thanks a lot.

       

      Regards,

       

      Ignas

       

       

  • 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