Forum Discussion
HemanthV
Helper II
Helper IICurrent category count subtract with remaining categories count
Hi Guys, I have the data as below NamescyclesDate A -1 01-01-2020 A -1 02-01-2020 A 0 03-01-2020 A 1 04-01-2020 A 1 05-01-2020 A 1 05-01-2020 A 1 06-01-2020 A...
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 )
Jihwan_Kim
Super User
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 )
HemanthVHelper II
Helper II