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 )
Super UserSorry 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?
Helper III 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.
- HemanthV
Hi Jihwan_Kim,
The solution worked but, i am struggling to get this. currently we are showing the percentages for all values right. excluding -1 values it should consider only values from zero to 4 and that is the total, and the percentages need to be shown as below
expected output:
Thanks in advance!