Forum Discussion
Helper IIIHow to Pass result of One Measure second table without Applying any other Filters?
I have following requirement. Please check the right side table where I have name and Dyanmic Row number generated. I have also uploaded sample file here. Please sownload from here.
Measure for the Dynamic Row Number is below.
RowNum =
CALCULATE (
COUNT ( Table1[Index] ),
FILTER ( ALLSELECTED( 'Table1' ), Table1[Index] <= MAX ( Table1[Index] ) )
)Now, I want to display the same Row number in all seperate table.
Problem: When I add my measure in every table it starts with "1" always. It doesn't resume the sequence number.
Suppose, if user filter two names, from the filter, at that time generated dynamic result of the measure should be displayed in the Power BI table.
Can anyone guide me how to achieve this requirement?
2 Replies
Are you trying to create an index column and have it always show that same index number? I recommend using PowerQuery for creating the index. It is much simpler.
https://yodalearning.com/tutorials/learn-how-create-index-columns-using-power-query/
- v-diye-msft
Community Support
Hi Dhruvin
In your scenario, if you'd like to get below results, please kindly change the measure as:
RowNum = var a = MAX(Table1[Name]) Return IF(a in VALUES('Table'[Slicer]),CALCULATE(COUNT(Table1[Index]),FILTER(ALL(Table1),[Name] in VALUES('Table'[Slicer])&&[Index]<=MAX(Table1[Index]))))
