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 Userhttps://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!
- Jihwan_Kim
Thank 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?