Forum Discussion

Happy2023_05's avatar
Happy2023_05
Icon for Helper I rankHelper I
3 years ago
Solved

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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    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.

Happy2023_05's avatar
Happy2023_05
Icon for Helper I rankHelper I
3 years ago

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_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
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.