Forum Discussion
Helper IICurrent category count subtract with remaining categories count
https://www.dropbox.com/s/xgf8cztetxl562t/Sample.pbix?dl=0
Expected Output : =
VAR currentcycle =
MAX ( 'Dim Cycles'[cycles] )
VAR countrownormal =
COUNTROWS ( Table1 )
VAR countrowcondition =
countrownormal
- CALCULATE (
COUNTROWS ( Table1 ),
FILTER ( ALL ( 'Dim Cycles' ), 'Dim Cycles'[cycles] > currentcycle )
)
RETURN
IF ( currentcycle <= 0, countrownormal, countrowcondition )
Helper IIHi Jihwan_Kim ,
The solution worked but the column totals are showing wrong
instead of 8,8,10 it is displaying 15,16,13. can you help me with this
Thanks in advance!
Super UserThank you for the feedback.
Please check the link down below.
https://www.dropbox.com/s/xgf8cztetxl562t/Sample.pbix?dl=0
- HemanthV
Hi Jihwan_Kim ,
Thank you so much! But i am curious that is it possible to find the percentages for values.
I will use this percentages in another matrix.I am using the following measure for percentage
Percentage_new =var cnt = [Expected Output :]var totalcnt = CALCULATE(COUNT(Table1[cycles]),ALL(Table1[cycles]))var percentage = DIVIDE(cnt,totalcnt)*100returnpercentage- Jihwan_Kim
Sorry that I quite do not understand what you are looking for.
Is [percentage_new] showing the result that you expected?
What is your expected outcome?
- HemanthV
I want to see percentage for the values
In the above pic
each value should be divided by total right for percentage
for example
for "A" the percentages are 25,12.5,50,0,0,12.5 right, but i am getting wrong values.2/8*100, 1/8*100, 4/8*100, 0/8*100, 0/8*100, 1/8*100
can you help me with this.