Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table with the following data.
Path | Segment | Criteria | Value |
Northbound | 190F | Default | 276000 |
Northbound | 190F | Increase | 132300 |
Northbound | 210B | Default | 286000 |
Northbound | 210B | Increase | 132300 |
Northbound | 220B | Default | 95000 |
Northbound | 220B | Increase | 75000 |
Northbound | 230B | Default | 95000 |
Northbound | 230B | Increase | 75000 |
Northbound | 240B | Default | 95000 |
Northbound | 240B | Increase | 75000 |
Northbound | 250B | Default | 95000 |
Northbound | 250B | Increase | 75000 |
Northbound | 260B | Default | 95000 |
Northbound | 260B | Increase | 75000 |
Northbound | 300B | Default | 95000 |
Northbound | 300B | Increase | 75000 |
Northbound | 310B | Default | 95000 |
Northbound | 310B | Increase | 75000 |
Southbound | 190B | Default | 231800 |
Southbound | 190B | Increase | 109200 |
Southbound | 210F | Default | 237350 |
Southbound | 210F | Increase | 110700 |
Southbound | 220F | Default | 235350 |
Southbound | 220F | Increase | 110100 |
Southbound | 230F | Default | 262000 |
Southbound | 230F | Increase | 110100 |
Southbound | 240F | Default | 261000 |
Southbound | 240F | Increase | 109800 |
Southbound | 250F | Default | 259000 |
Southbound | 250F | Increase | 109200 |
Southbound | 260F | Default | 258000 |
Southbound | 260F | Increase | 108900 |
Southbound | 300F | Default | 306000 |
Southbound | 300F | Increase | 123300 |
Southbound | 310F | Default | 306000 |
Southbound | 310F | Increase | 123300 |
I need to display the path and the minimum sum ( value) of all segments within the path. I also want to be able to create a slicer on the Criteria column.
So if both Default and Increase are selected in the criteria slicer, my output should be:
Path | Min Value |
Northbound | 170000 |
Southbound | 341000 |
If just Default is selected in the criteria slicer my output should be:
Path | Min Value |
Northbound | 75000 |
Southbound | 231800 |
Thanks for your help.
Solved! Go to Solution.
Hi @Raymo3u99 ,
could you give an overview over your model?
I think you only have to replace the data[path] with the pathitems.
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @Raymo3u99
Try this:
@mwegener Thanks for the solution. It gives me the right answer. However I am unable to get subtotals on this column if there are more than one paths in a higher group. Any thoughts as to why it won't allow subtotals?
Hi @Raymo3u99 ,
could you give an overview over your model?
I think you only have to replace the data[path] with the pathitems.
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |