Forum Discussion
Happy2023_05
3 years agoHelper I
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...
- 3 years ago
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.
Ashish_Mathur
3 years agoSuper User
Hi,
From the Dimtable, drag the Store name to the table visual. Drag the Not submitted measure as well.
- Happy2023_053 years agoHelper I
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?
- Ashish_Mathur3 years agoSuper User
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.