Showing dimension in table conditionally

johnnyjohn — Thu, 26 Mar 2020 13:05:19 GMT

I want to display [Commissions.CUSTOMER] if the distinct number of Commissions.INC_COMM_LEDGER is greater than one in the past month (Commissions.TRADE_MONTH_START)

I used this

=IF(COUNT({$<[Commissions.TRADE_MONTH_START]={'$(=Monthstart(Date(today(),'M/D/YYYY')))'}>} Distinct [Commissions.INC_COMM_LEDGER]) > 1,[Commissions.CUSTOMER])

If I put this condition as a measure and show True or False, like shown below, it works, but when filtering out the dimension it says invalid dimension.

=IF(COUNT({$<[Commissions.TRADE_MONTH_START]={'$(=Monthstart(Date(today(),'M/D/YYYY')))'}>} Distinct [Commissions.INC_COMM_LEDGER]) > 1,"True", "False")

How can I do only show the dimension CUSTOMER when this condition is true in my table?

Many thanks

Re: Showing dimension in table conditionally

lorenzoconforti — Thu, 26 Mar 2020 14:08:15 GMT

You need to add [Commissions.CUSTOMER] as a normal dimension

then, under "show column if" just write this:

=COUNT({$<[Commissions.TRADE_MONTH_START]={'$(=Monthstart(Date(today(),'M/D/YYYY')))'}>} Distinct [Commissions.INC_COMM_LEDGER]) > 1

topic Re: Showing dimension in table conditionally in App Development

Showing dimension in table conditionally

Re: Showing dimension in table conditionally