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, 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!
- HemanthV
Hi Jihwan_Kim ,
I need some help from you.
I need -1 to 6 columns in one table and:1) For -1, I need Cycle table count.
2) from 0 to 6 I need which_day table count
Thanks in advance!