Can someone help in acheiving below count in Power BI.
Go to Solution.
@titusissam try following measure
CALCULATE( COUNTROWS( Table1 ),
FILTER( ALLEXCEPT( Table1, Table1[Name] ),
Table1[Index] <= MAX( Table1[Index] ) ) )
Proud to be a Datanaut! Kudos Help Connect with me on Linkedin. Feel free to email me with any of your BI needs.
@titusissam did you tested the measure I sent to you. i tested at my end it works
@titusissam you need to have some sort of index or date to calculate running total. What other columns you have in model?
@titusissam you need to have date or index column in your model to calculate running total.
Thanks for your reply @parry2k
yes i do have an index column which has row number in it.
yea i got this answer based on an earlier post, but i want the occurance number.
Eg., If "A" repeats 10 times count column should have 1,2,3, etc.,
Thanks again for your help on this..
yea working fine in measure.. thank u....