Forum Discussion
PRICE RANGE REPORT
I have 3 files and 1 of this is connecting file. The masterfile (relationship). Now, 1 need a DAX that will determine or create report base on different category with different price range bas...
Hi Anonymous,
Here I made one sample for your reference, You can refer to the following steps.
1. Enter the data and create a calculated table using the formula.
un = DISTINCT('FILE 3'[CATEGORY])2. Create the relationship between tables as below.
3, Create a measure and make the table filtered by the measure.
Measure = IF(ISBLANK(MAX('FILE 2'[PRICE])),BLANK(),IF(MAX('FILE 2'[PRICE])>=MAX('FILE 3'[MIN]) &&MAX('FILE 2'[PRICE])<=MAX('FILE 3'[MAX]),1,BLANK()))
For mroe details, please check the pbix as attached.
https://www.dropbox.com/s/mfp7sif6aay8jl6/PRICE%20RANGE%20REPORT.pbix?dl=0
Regards,
Frank
Hi Anonymous,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank