Forum Discussion

Dhruvin's avatar
Dhruvin
Icon for Helper III rankHelper III
7 years ago

How 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 ...
Need Help
Show and Tell
v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
7 years ago

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]))))