Forum Discussion
DAX Help
Suppose we have Dimtable and facttable are in one to many relationship and 3 measures created like this.
total str=distinctcount(dimtable[str])
Submitted str=calculate(distinctcount(facttable[str]),condn)
Not submitted str= total str- submitted str
Now I want to show list of not submitted stores in table format.
Not submitted str--this will give the count but want to see the store names of tht.
how can we achieve this in DAX?Kindly help.
Hi,
Remove that measure from the table visual and drag it to the filter pane in the "Filter on this visual" well. Apply the filter confdition there.
3 Replies
Hi,
From the Dimtable, drag the Store name to the table visual. Drag the Not submitted measure as well.
Thanks for your reply Ashish_Mathur .@ But if you do that way, not submitted value is shown.but i dont want to show it.ust the store name alone in table visual.is there a way to do it?
Hi,
Remove that measure from the table visual and drag it to the filter pane in the "Filter on this visual" well. Apply the filter confdition there.
