Forum Discussion

gthangav's avatar
gthangav
New Member
3 years ago

Help with measure

I am looking to filter a data set using measure, i have the following measure to calculate the sum of cumulative value to date- 

Cumulative Actual HOURS = (CALCULATE
(IF(SUM(Track[net_billable_time])=BLANK(),0,SUM(Track[net_billable_time])),
FILTER(ALL('Calendar'[Date]),'Calendar'[Date]<=
MAX('Calendar'[Date])))*
IF(MAX('Calendar'[Date])<TODAY(),1))
 
Now, I am looking to add another filter to the same measure to " filter a group of data (directs) from another column from the same table" I created a group from right-click the column name under fields and created the group. please let me know how this is possible.

 

 
Thank you and appreciate the help.
Tips and Tricks

1 Reply

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    These measures should work

    NBT = SUM(Track[net_billable_time])

    NBT YTD = calculate([nbt],datesytd(calendar[date],"31/12"))

    31/12 is the end of the Financial year.

    In the calculate function, you may give as many comma seperated AND conditions.

    Hope this helps.