Forum Discussion
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...
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
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
