Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table with about 17 000 records. I have created a textboox with a Count(Distinct(TradeName)) which counts the number of distinct TradeNames in the straight table as is illustrated below:
The distinct count of TradeName gives a value of 3801 as illustrated above. I would want this value to change based on various selections with various dimension values for example filter by date which should reduce the number 3801.
How can this be accomplished in QV?
Shouldn't you be counting [FDA Trade Name] ?
It should work automatically with this expression: Count(Distinct(TradeName))
You no need to do anything..
If your selected Dimension is associated with TradeName...It will change as per your selection
I think it should already change if this -> Count(DISTINCT TradeName) is what you are using. It is not filtering based on selections?
Many thanks, it is not changing based on any selections.
Hi Sunny
There are no changes based on any selections.
Is the table 'Detached'?
HI Roger, thanks, it is not detached.
My data model is as below:
Sample Data?
Shouldn't you be counting [FDA Trade Name] ?
I cannot see field TradeName in your Data Model.
Should it be Count ( Distinct ( [FDA TradeName] ) ) ?
Or maybe I am missing something.