Forum Discussion
Helper IVPercentage calculation by month
Mous007 - Try:
My weekday % split calc is = weekday % split for office w = DIVIDE(CALCULATE(COUNTA('data sample'[Day Name]), 'data sample'[Location] = "Office"), CALCULATE([Office attendance] , ALLSELECTED('Dates table')))Otherwise, going to need sample data to test with.
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
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Community ChampionMous007 - Try:
My weekday % split calc is =
weekday % split for office w = DIVIDE(CALCULATE(COUNTA('data sample'[Day Name]), 'data sample'[Location] = "Office"), CALCULATE([Office attendance] , ALLSELECTED('Dates table')))Otherwise, going to need sample data to test with.
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
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Helper IVHi Greg_Deckler , thank you for the quick reposnse.
allselected instead of all solved it.
thanks again