Forum Discussion
PRICE RANGE REPORT
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
- Hi Sir, I haven't tested it yet. I'll get back to you as soon as I've checked it.
Hi v-frfei-msft,
Error encountered. Is that because some of Max value is " above" and not numeric? If yes , how can i show its morethat range high more than min.
Hi Anonymous,
Yes, so you should replace the Above to numeric.
Regards,
Frank
Hi v-frfei-msft,
The folrmulate doesnt work. QTY sold sum up and once i click ranges same qty reflected.
Thank you,