Filtered Table in a Visual

DAX DAX Calculations
1

Hi all,

I have a fact table of product sales pulled from a database and I would like to show a section of that table in a visual (table or matrix) the section being products meeting a condition set in a data picker.

As far as I know it is impossible to create a formula table using a variable (selectedvalue) in a table filter, but maybe there is some other workaround??

My table looks as follows:
https://www.mediafire.com/view/ivhax2ljbtl5989/Table.jpg/file

I will appreciate any guidance.
Thanks
Lukasz

1 Like
2

@cleverclog,

This is quite straightforward to accomplish with a disconnected date slicer and a filter on the visual in the filter pane:

image
image751×461 14.2 KB

Here’s the key measure:

Within Range = 

IF(
    AND(
        SELECTEDVALUE( 'Table'[Date In] ) <= [Harvest Disconn Date],
        SELECTEDVALUE( 'Table'[Date Out] ) > [Harvest Disconn Date]
    ),
    1,
    0
)

I hope this is helpful. Full solution file attached.

  • Brian

eDNA Forum - Filtered Table Soluution.pbix (87.5 KB)

3 Likes
3

Thank you very much BrianJ! That’s what I need.
I kept trying with tables and formulas but it was a dead end.

4

@cleverclog,

Great – glad that got you what you needed.

I can see why you ran into trouble trying to do this without the use of the filter pane. The humble filter pane definitely does not get enough respect. Check out the post below as proof -

using the filter pane - 1 line of DAX
not using the filter pane – 59 lines of complex DAX

  • Brian