Filtering whole dataset based on 2 parameters

[varelapablo90]

Hello Power BI Community

I need to create the following dashboard to run an analysis on some data.

My data set contains 2 tables:

1. Information on Invoice Level (header) 
2. Item Level (every item bought on each invoice).

The main focus is on the slicers that need to filter the Invoice values and Item values.

Currently everthing is working fine except that I need these slicers to work as the picture below from excel:

Having the following dataset as an example, how is it possible to use the slicers to filter as follows?

If at least one value is above the threshold selected by the user the invoice shouldnt be displayed at all.

User selects Invoice value < 300 & Item value <100 (only Invoice A should be displayed) 

Currently Invoice A & B are displayed.

If at least one Item value from the Invoice is above the limit selected by the user then dont show any data at all.

Look forward for your help

Thanks in avance.

[SpartaBI]

@varelapablo90 can you share the excel file instead of the pic or even better the PBIX file itself?

[varelapablo90]

Cant share files here 😥

https://drive.google.com/file/d/1sj1_kZ0RA8QDT8TmspZ3mVU3vAisSfNu/view?usp=sharing

[SpartaBI]

@varelapablo90 
step 1:
create this calculated table:

Item Prices = ALLNOBLANKROW(Item_Level[Item Amount])
step 2:
use the column from this table instead of the column from the items table in the slicer.
step 3: create this measure:

Test for max item amount =

VAR _selected_threshold = MAX('Item Prices'[Item Amount])

VAR _max_item_amount = MAX(Item_Level[Item Amount])

RETURN

INT(_max_item_amount < _selected_threshold)
step 4:
put that measure in the visual filter pane and set it to 1

Showcase Report – Contoso By SpartaBI

      

[varelapablo90]

I have updated the PBI file with the rawdata accordingly because it didnt work 😞

https://drive.google.com/file/d/1sj1_kZ0RA8QDT8TmspZ3mVU3vAisSfNu/view?usp=sharing

[SpartaBI · Accepted solution]

@varelapablo90 hey, take a look at this:
https://spartabiltd-my.sharepoint.com/:u:/g/personal/avishayf_spartabi_com/EdiHT7W28QJGpP7JBMXZHGQB-...
In my solution you need to put the invoice in the rows. (That was the original post).
Is that what you need?
I also changed some stuff in your model that wasn't right regardless of the question.

[varelapablo90]

help 😞