Forum Discussion
Create a Measure which Returns a Certain Value from a Cumulative Measure
Hi! I wanted to create a measure which will return a specific value which is computed using a cumulative total. For example, I only want to get the Cumulative Target for Week 5 which is 2064. Note ag...
Hi Anonymous
This worked for me and I have attached a basic PBIX file.
Measure = CALCULATE([Cumulative Target],'Table1'[Week]="Week 5")
Figured it out. I just have to use <= instead of an equal sign for the Week in Measure. Thanks a lot Phil_Seamark :smileyvery-happy:
Measure = CALCULATE([Cumulative Target],'Table1'[Week] <= "Week 5")
Hi Anonymous
This worked for me and I have attached a basic PBIX file.
Measure = CALCULATE([Cumulative Target],'Table1'[Week]="Week 5")
Figured it out. I just have to use <= instead of an equal sign for the Week in Measure. Thanks a lot Phil_Seamark :smileyvery-happy:
Measure = CALCULATE([Cumulative Target],'Table1'[Week] <= "Week 5")