Forum Discussion
Helper IIFiltering whole dataset based on 2 parameters
varelapablo90 hey, take a look at this:
https://spartabiltd-my.sharepoint.com/:u:/g/personal/avishayf_spartabi_com/EdiHT7W28QJGpP7JBMXZHGQB-ERe4tPuwzrBFouwCgBH8w?e=5f680r
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.
Community Championvarelapablo90 can you share the excel file instead of the pic or even better the PBIX file itself?
Helper IICant 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])RETURNINT(_max_item_amount < _selected_threshold)
step 4:
put that measure in the visual filter pane and set it to 1- 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
varelapablo90 hey, take a look at this:
https://spartabiltd-my.sharepoint.com/:u:/g/personal/avishayf_spartabi_com/EdiHT7W28QJGpP7JBMXZHGQB-ERe4tPuwzrBFouwCgBH8w?e=5f680r
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.