I am building a dashboard which has a few tables which are a cut of a overall dataset filtered to the right data.
I am now trying to put a table together which has measures and trying to SUM this number at the end but struggling to do so.
The table is as follows :
I would like a column at the end which totals the SUM of the row per employee ID.
The employee ID is taken off a staff data table [table 1]
The measures all sit within this staff data table and are as follows and link back to the individual tables :
Solved! Go to Solution.
Hi @indyb ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
I don't see the table. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That works! Thanks @Greg_Deckler I was trying all the complicated ways - SUM(, CALCULATE(, COUNT( etc but didnt think to go back to basics!!
But furthur on from that, im trying to get this measure as a percentage of the total of measures where a value is populated and have this as 100%.
Hi @indyb ,
We can try to use the following measure to get the percent value:
Percent Of Measure = VAR currentMeasure = SUMX ( DISTINCT ( 'Table 1'[employee ID] ), CALCULATE ( [Measure] ) ) VAR measureTotal = SUMX ( CALCULATETABLE ( DISTINCT ( 'Table 1'[employee ID] ), ALLSELECTED () ), CALCULATE ( [Measure] ) ) RETURN DIVIDE ( currentMeasure, measureTotal, 0 )
Percent Of Measure = VAR currentMeasure = CALCULATE ( [Measure] ) VAR measureTotal = CALCULATE ( [Measure], ALLSELECTED () ) RETURN DIVIDE ( currentMeasure, measureTotal, 0 )
If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to OneDrive For Business and share the link here.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Mark your calendars and join us for our next Power BI Dev Camp!