Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX - Summarize Filter Logic

Dear Power BI Community,   I am trying to accomplish a histogram of the distribution of overtime hours by employees. Axis = Total Hours (Groups), Values = Total Hours.   My table is set up like t...
  • az38's avatar
    az38
    6 years ago

    Hi!

    calculated table will not affected by slicers

    but you can create a measure in your SummarizeTable

    TotalHoursMeasure = calculate(SUM('Table1'[Hours]),FILTER(ALLEXCEPT('Table1';Table1[Check Date]),Table1[ID]=SELECTEDVALUE('SummarizeTable'[Table1_ID])))

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    LinkedIn

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi!

calculated table will not affected by slicers

but you can create a measure in your SummarizeTable

TotalHoursMeasure = calculate(SUM('Table1'[Hours]),FILTER(ALLEXCEPT('Table1';Table1[Check Date]),Table1[ID]=SELECTEDVALUE('SummarizeTable'[Table1_ID])))

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thats awesome thank you - I was hoping to be have this as a column so then I can do a histogram off of the total hours, any ideas?