Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
PBI5851
Helper V
Helper V

Using a measure in a summarize column

Hello, I am trying to build a forecast model and below is the raw data. 

TM_NameShippedCount
John10
jack30
Jim24
Jordan35
Jackie20
Jeanie10
Joe8
James15

I have created three measures. 

Current Ship Month = CALCULATE(sum(CountTable[ShippedCount]))
 
Next Ship Month+1 =
var __table = ADDCOLUMNS(SUMMARIZE(CountTable, CountTable[TM_Name]), "@CurrentShipMonth+1",[Current Ship Month])
Return
    SUMX(
        __table,
        IF([@CurrentShipMonth+1] <= 35, [Current Ship Month]+([Current Ship Month]*0.10), [Current Ship Month]+ ([Current Ship Month]*.20))
    )
 
Next Ship Month+2 =
var __table = ADDCOLUMNS(SUMMARIZE(CountTable, CountTable[TM_Name]), "@CurrentShipMonth+2",[Next Ship Month+1])
Return
    SUMX(
        __table,
        IF([@CurrentShipMonth+2] <= 35, [Current Ship Month]+([Current Ship Month]*0.15), [Current Ship Month]+ ([Current Ship Month]*.25))
    )
 
I get the data like below. 
PBI5851_0-1701984571225.png
Now i need to create a table which should give me under each of the columns, the number of TM's whose count value is more than 17. The expected visual should be like PBI5851_1-1701984801773.png and ideally lined up under the respective columns. 

 

1) Is it possibile to get Month and Year value dynamically (20203-12, 2024-01, 2024-02) instead of Current Ship Month , Next ShipMonth+1 etc.
2) How do i get the Count_more_than17 as I am unable to use the measures created in another summarize table to re-use it for calclation. 
 
Any recommendations please. 
2 REPLIES 2
amitchandak
Super User
Super User

@PBI5851 , for that you need to dynamic segmentation on the measure and create three new measure to use bucket based on current month values

 

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...


Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak Thank you for that solution, but unfortunately, it will not work completely as (due to my incomplete info in the question), there is a second part of the request where the count_of_17 measure is to use the current ship month and next ship month measures itself. 
ex: if nextshipmonth+1 > currentshipmonth then 1 else 0. Using your solution, i dont have set parameter like you have in the start and end limit.  Any other suggestion on how to use the measure as a calculation parameter. 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.