Count selected IDs with filtering removed

Question

Hi,&nbsp;Data like this:&nbsp;&nbsp;creates a matrix like this;&nbsp;and when ckicked a table like this:I want to create a measure that counts the IDs 2 or 3 for the different date and stage, so I can visualise it like this:&nbsp;In DAX I can use the following code, but struggle how to define the VAR selected_ids dynamically.&nbsp;I tried to use VALUES on the [ID], but it selects alll the possible IDs.&nbsp;&nbsp;&nbsp;Thanx!&nbsp;

amitchandak · Answer

WJ_WJ , Try if this solution can help
&nbsp;
Power BI Partial Interactions, Selectively pass filter across visuals - https://youtu.be/SFEKQEic_sk

wj_wj · Answer

Thx for your reply, but Im looking for&nbsp; a fully DAX solution. Should be possible...

anonymous · Answer

I'm not sure why you'd always want just id 2 and 3, you could use a slicer for a dynamic selection but if you want it hardcoded try:Test =&nbsp;VAR _table = FILTER('stagesTbl',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'stagesTbl'[id] = 2 || 'stagesTbl'[id] = 3)RETURNCOUNTX(_table, COUNT('stagesTbl'[id]))

wj_wj · Answer

Thx for the reply. I dont want it hard copied. An this is sample data, a slicer would show to much IDs in the real data. I tried to use the select all option for a slicer, but it selects all the know IDs, not only the one for a specific date and stage...

anonymous · Answer

I'm a bit confused as that seemed to be what you were asking for in your original post? If you want to filter by date and stage can't you just add slicers for those?

Forum Discussion

Count selected IDs with filtering removed

7 Replies

Related content

Removing date filter

Remove visual filter context

Remove filter on visual

Remove drill through filters

Removing Drill Down Filters