DAX Help

[Happy2023_05]

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.

[Ashish_Mathur]

Hi,

From the Dimtable, drag the Store name to the table visual.  Drag the Not submitted measure as well.

[Happy2023_05]

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 · Accepted solution]

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.