User Profile
Dharini
Frequent Visitor
Joined 8 years ago
User Widgets
Contributions
Re: Dynamic ranking a column based on slicer created from master table
PattemManohar Thanks for your quick reply. This measure works fine when region slicer is created is created from Test table . But when Region slicer is created from master table Region, Data is not filtered as given below in Test table When Test1 is selected from region slicer, below data is displayed Region ProjectId Value Rank Test1 1 23 3 Test1 2 34 2 When Test1 and Test4 is selected in Region slicer , below data is displayed Region ProjectId Value Rank Test1 1 23 3 Test1 2 34 2 Test4 5 17 4 Test4 6 17 42.6KViews0likes2CommentsDynamic ranking a column based on slicer created from master table
Hi All, I have a slicer called Region(from master table - Region) which has relation to Region field in Test table. Region Test1 Test2 Test3 Test4 I have to dynamically rank the Test table based on value column depending on slicer selection - Region. I have data for test table as given below. Region ProjectId Value Test1 1 23 Test1 2 34 Test2 3 53 Test3 4 9 Test4 5 17 Test4 6 17 If Test1 is selected in Region slicer, then it should be displayed as below, Region ProjectId Value Rank Test1 1 23 2 Test1 2 34 1 If Test 2 and Test 3 is selected in Region slicer,then it should be displayed as below , region ProjectId Value Rank Test2 3 53 1 Test3 4 9 2 If Test 2 and Test 4 is selected, then it should be displayed as below, Region ProjectId Value Rank Test2 3 53 1 Test4 5 17 2 Test4 6 17 2 If All is selected in slicer,then it should be displayed as , Region ProjectId Value Rank Test1 1 23 3 Test1 2 34 2 Test2 3 53 1 Test3 4 9 5 Test4 5 17 4 Test4 6 17 4 i have created a rank measure as Rank = RANKX(ALLSELECTED('Test'),CALCULATE(SUM('Test'[Value]),ALLEXCEPT('Test',Region[REGION],'Test'[ProjectId])),,DESC,Dense). This works fine when region slicer is created from test table. But i wanted to dynamically rank the value column based on selection from region slicer(master). Kindly do help. Thanks DhariniSolved2.6KViews0likes5CommentsRe: Set slicer value based on selection of another slicer
v-danhe-msft Thanks for your reply. I have requirement where selection in first slicer( from master table), should automically be selected in second slicer too(from test table). For example ,if i select in first slicer(master) say first EMEA is selected and APJ is selected secondly as given below Here i have used chicklet slicer (with forced selection option) for second visual, so the first one EMEA selected in first slicer gets selected automatically (in green), but not the second one(in yellow). I want all the values to be selected in second slicer depending on first slicer selection. Based on second visual values selected other visuals in report will change the data. Is there any other slicers for enabling multiple options for above scenario. Kinldy help me.9.1KViews1like2CommentsSet slicer value based on selection of another slicer
Hi All, I have two slicers , one slicer is region which is from Region master table Another slicer which is from Test table and has same region field which has table level relation to Region master table And lists as below. If i select Region in master slicer( say Americas), then same(Americas) should automatically set in Region slicer which is from Test table . Is this possible in slicer level. Kindly do needful. Thanks9.1KViews0likes4CommentsIsFiltered not working
Hi All, I have a Test slicer which drop downs test1,test2, test3. Based on the slicer selection, Table visual is changed accordingly( have relation with the slicer data and visual table) If single selection is made ie say test1, Test1 related data is presented in table and i have a measure column in same table and wanted to display the output as Measure1 And if multiple selection is made or All option is selected in slicer, i want measure column to output as Measure 2. For this , i have used the measure column as below, FinalRes = IF(ISFILTERED(TestTable(Test)), Measure1,Measure2) which doesnot work and always returns the Measure2 value. Kindly do needful.Solved3.9KViews0likes1CommentRe: create rank column based on column using dax
LivioLanzo Thanks for your help!! but i am stuck with the calculation I have created a column as you has specified with ranking order to be desc as given below. Column = VAR CurVal = [Text Value] RETURN CALCULATE( RANKX( Data, [Text Value], CurVal, Desc, Dense ), ALLEXCEPT( Data, Data[Region] ) ) For the dataset given below, calculated column is working as shown . Region ProjectName Text Value Expected RNK Test1 wewqe 5.00 1 Test1 yuy 5.00 1 Test2 ty 20.35 1 Test2 ty 5.00 2 Test3 wewrt 48.73 3 Test3 frtrre 78.39 2 Test3 sdada 5.00 1 For the Region "Test3" , rank is calculated wrongly as shown above. Rank should be calculated as Test3 wewrt 48.73 2 Test3 frtrre 78.39 1 Test3 sdada 5.00 3 Kindly do needful.28KViews0likes1Commentcreate rank column based on column using dax
Greetings !! I have a region slicer which drop downs as Test1, Test2 , Test3. And a Rank slicer which has ranges and occurs based on the Rank column. i have data set given below . Region ProjectName Text Value Rank Expected RNK Test1 wewqe 5.00 1 1 Test1 yuy 5.00 1 1 Test2 ty 20.35 2 1 Test3 ert 48.73 3 1 Test3 ertrre 78.39 4 2 Test3 sdada 78.39 4 2 The above calculation for Rank column is if text value is same, rank is same and increases on next values irrespective of region column . I am in need of help in creating rank column (Expected RNK) as shown above. ie based on both the text value and region column. If test 2 is selected in Region slicer and Rank slicer is set to 1, then i need result as given below . Region ProjectName Text Value Rank Expected RNK Test2 ty 20.35 2 1 Please help me out.Solved28KViews1like4Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.