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

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