Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
there were some difficulties with the last thread, so I figured it would be good to create a new one to get the answer I need.
I have a "Line a clustered column chart" as following:
Anyways, I have a "Line a clustered column chart" with the line as a quite complex measure and x-axis as date. I have a slicer that affects the date.
I also have a table with part number and qty in stock.
Is there a way to get the max and min value for the line/measure based on the date-slicer? In the graph if nothing is selected, the line will be the sum of qty in stock within the date selection, but if I click on part number 123, I would only see that part number's qty in stock. Is it doable?
Part Number | Qty in stock (now) | Min in stock |
123 | 100 | 0 |
234 | 120 | 70 |
345 | 80 | 80 |
567 | 70 | 0 |
Thanks in advance. Might be a better way to do it, but I thought it was weird that you couldn't do MIN of a measure.
Solved! Go to Solution.
Hi @Anonymous ,
We can try to use the following measure to meet your requirement.
min measure = CALCULATE(MINX(DISTINCT('Table'[Part Number],'Table'[sum Qty]),ALLSELECTED('Table'))
You can replace the ‘Table’[sum Qty] with your measure and replace ‘Table’[Part Number] with your field used in x-axis
Then We can get the result like this,
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Hi @Anonymous ,
We can try to use the following measure to meet your requirement.
min measure = CALCULATE(MINX(DISTINCT('Table'[Part Number],'Table'[sum Qty]),ALLSELECTED('Table'))
You can replace the ‘Table’[sum Qty] with your measure and replace ‘Table’[Part Number] with your field used in x-axis
Then We can get the result like this,
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
OMG I LOVE YOU!
Thanks so much!😍
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |