User Profile
Rakesk13
Helper III
Joined 2 months ago
User Widgets
Contributions
Re: Adding additional record as in Drop down selection/Filter Selection.
Hi , Its really Thanks for such quick reply, But in Analyst Columns i am unable to get “COMPLTAED” ,”IN PROGESS”, ”STOP" filter selection for export of data. i am looking for “COMPLTAED” ,”IN PROGESS”, ”STOP" data in same Analyst Column. Please let me know how it will work. Its really appreciate foir quick reply. Thanks Rakesh JadhavAdding additional record as in Drop down selection/Filter Selection.
Hi Team, PF details below : Name Product Analyst AA sdfgsdfZZZ BB fer34r45y5 CC jhjyjhh ZZZ AA ggrgr BB Not FD gora ZZZ HE only is HE HOEEZZZ BD gfgrg I have created Dax – Analyst = SWITCH(TRUE(),CONTAINSSTRING(Sheet1[Product],"ZZZ"),"IN",Sheet1[Name] IN {"AA","BB","HE"},"OUT",BLANK()) In Analyst Columns I need additional record as “COMPLTAED” ,”IN PROGESS”,”STOP” as Drop down selection/Filter Selection. How we can add “COMPLTAED” ,”IN PROGESS”, ”STOP” in data in Analyst Columns. Thanks & Regards, Rakesh JadhavRe: How to apply Slicer filter on un-matching record between two different table.
Hi Kushana, Really thanks for reply its help me out!! But i have relationship between Emp & Summary table with EMP_ID ,but you have created with Relation field. While Creating relationship with relation field its giving different output. Please can you help on this. Thanks & Regards, Rakesh JadhavRe: How to apply Slicer filter on un-matching record between two different table.
How to Apply filter to Un-matched records of two different table Hi Team, I have data like this: Emp Details: EMP ID _DE EMP Name_De Age amt Relation 1 A 1 1000 QW 2 B 2 45 QW 3 C 3 2000 QW 4 D 6 3444 QW 6 F 7 1652 QW 12 CC 12 67 RR 23 GG 34 6666 QW 56 A 44 3333 RR 11 A 12 5555 RR 15 A 14 6666 QW 34 C 16 3555 RR 36 D 56 1333 RR 41 F 11 3444 QW 99 SE 4 967 RR EMP SUMM : EMP ID EMP NAME Age Amt Relation 5 E 4 2333 QW 6 F 2 45 RR 1 A 23 67 QW 11 AA 18 45 RR 12 BB 13 45 QW 13 CC 31 7777 QW 14 DD 80 5 QW 15 FF 11 2 RR 17 F 23 89 QW 18 CC 1 1200 QW 36 WW 4 454 RR 36 QG 6 65 RR 22 TB 2 156 RR I need to apply Relation filter to visualization are not changing/applying . 1) More test = var _distDet = DISTINCT(Sheet1[EMP ID _DE] ) //unique Details Ids var _distSumm = DISTINCT('Sheet1 (2)'[EMP ID]) //unique Summary Ids var _commonIDs = INTERSECT(_distDet, _distSumm) //unique Ids found in both tables var _unqDet = COUNTROWS(_distDet) - COUNTROWS(_commonIDs) //count of unique Details Ids not in common table var _unqSumm = COUNTROWS(_distSumm) - COUNTROWS(_commonIDs) //count of unique Summary Ids not in common table RETURN _unqDet //+ _unqSumm 2) More test_Unmatch = var _distDet = DISTINCT(Sheet1[EMP ID _DE] ) //unique Details Ids var _distSumm = DISTINCT('Sheet1 (2)'[EMP ID]) //unique Summary Ids var _commonIDs = INTERSECT(_distDet, _distSumm) //unique Ids found in both tables var _unqDet = COUNTROWS(_distDet) - COUNTROWS(_commonIDs) //count of unique Details Ids not in common table var _unqSumm = COUNTROWS(_distSumm) - COUNTROWS(_commonIDs) //count of unique Summary Ids not in common table RETURN //_unqDet + _unqSumm I do have two visualization More test and More test _Un-Matched ,which are un-match record of each other table. I am trying to apply Slicer but its not applying Properly on visualization , Relationship between table : We have Many to one relationship between table. Both table have Relation Field ,we can use any one of them to fiter. Expected Result looking for: If I select QW or RR from Slicer it should filter Un-Matched record from More test and Moretest_Unmatch from two different table. For EMP details table: QW Count :5 RR Count: 3 For Emp Summ table: QW Count: 5 RR Count 1 EMP ID EMP NAME Age Amt Relation Vlookup 5 E 4 2333 QW #N/A 13 CC 31 7777 QW #N/A 14 DD 80 5 QW #N/A 17 F 23 89 QW #N/A 18 CC 1 1200 QW #N/A 22 TB 2 156 RR #N/A EMP ID _DE EMP Name_De Age amt Relation Vlookup 2 B 2 45 QW #N/A 3 C 3 2000 QW #N/A 4 D 6 3444 QW #N/A 23 GG 34 6666 QW #N/A 56 A 44 3333 RR #N/A 34 C 16 3555 RR #N/A 41 F 11 3444 QW #N/A 99 SE 4 967 RR #N/A Please can you help on this. Thanks & Regards, Rakesh JadhavRe: How to Apply filter to Un-matched records of two different table
How to Apply filter to Un-matched records of two different table Hi Team, I have data like this: Emp Details: EMP ID _DE EMP Name_De Age amt Relation 1 A 1 1000 QW 2 B 2 45 QW 3 C 3 2000 QW 4 D 6 3444 QW 6 F 7 1652 QW 12 CC 12 67 RR 23 GG 34 6666 QW 56 A 44 3333 RR 11 A 12 5555 RR 15 A 14 6666 QW 34 C 16 3555 RR 36 D 56 1333 RR 41 F 11 3444 QW 99 SE 4 967 RR EMP SUMM : EMP ID EMP NAME Age Amt Relation 5 E 4 2333 QW 6 F 2 45 RR 1 A 23 67 QW 11 AA 18 45 RR 12 BB 13 45 QW 13 CC 31 7777 QW 14 DD 80 5 QW 15 FF 11 2 RR 17 F 23 89 QW 18 CC 1 1200 QW 36 WW 4 454 RR 36 QG 6 65 RR 22 TB 2 156 RR I need to apply Relation filter to visualization are not changing/applying . 1) More test = var _distDet = DISTINCT(Sheet1[EMP ID _DE] ) //unique Details Ids var _distSumm = DISTINCT('Sheet1 (2)'[EMP ID]) //unique Summary Ids var _commonIDs = INTERSECT(_distDet, _distSumm) //unique Ids found in both tables var _unqDet = COUNTROWS(_distDet) - COUNTROWS(_commonIDs) //count of unique Details Ids not in common table var _unqSumm = COUNTROWS(_distSumm) - COUNTROWS(_commonIDs) //count of unique Summary Ids not in common table RETURN _unqDet //+ _unqSumm 2) More test_Unmatch = var _distDet = DISTINCT(Sheet1[EMP ID _DE] ) //unique Details Ids var _distSumm = DISTINCT('Sheet1 (2)'[EMP ID]) //unique Summary Ids var _commonIDs = INTERSECT(_distDet, _distSumm) //unique Ids found in both tables var _unqDet = COUNTROWS(_distDet) - COUNTROWS(_commonIDs) //count of unique Details Ids not in common table var _unqSumm = COUNTROWS(_distSumm) - COUNTROWS(_commonIDs) //count of unique Summary Ids not in common table RETURN //_unqDet + _unqSumm I do have two visualization More test and More test _Un-Matched ,which are un-match record of each other table. I am trying to apply Slicer but its not applying Properly on visualization , Relationship between table : There is One to Many relationship between table. Both table have Relation Field ,we can use any one of them to fiter. Expected Result looking for: If I select QW or RR from Slicer it should filter Un-Matched record from More test and Moretest_Unmatch from two different table. For EMP details table: QW Count :5 RR Count: 3 For Emp Summ table: QW Count: 5 RR Count 1 EMP ID EMP NAME Age Amt Relation Vlookup 5 E 4 2333 QW #N/A 13 CC 31 7777 QW #N/A 14 DD 80 5 QW #N/A 17 F 23 89 QW #N/A 18 CC 1 1200 QW #N/A 22 TB 2 156 RR #N/A EMP ID _DE EMP Name_De Age amt Relation Vlookup 2 B 2 45 QW #N/A 3 C 3 2000 QW #N/A 4 D 6 3444 QW #N/A 23 GG 34 6666 QW #N/A 56 A 44 3333 RR #N/A 34 C 16 3555 RR #N/A 41 F 11 3444 QW #N/A 99 SE 4 967 RR #N/A Please can you help on this. Thanks & Regards, Rakesh JadhavRe: How to Count from two different table Un-matched record with New table
How to Apply Slicer filter to Un-matched records of two different table Can you help on this please. Hi Team, I have data like this: Emp Details: EMP ID _DE EMP Name_De Age amt Relation 1 A 1 1000 QW 2 B 2 45 QW 3 C 3 2000 QW 4 D 6 3444 QW 6 F 7 1652 QW 12 CC 12 67 RR 23 GG 34 6666 QW 56 A 44 3333 RR 11 A 12 5555 RR 15 A 14 6666 QW 34 C 16 3555 RR 36 D 56 1333 RR 41 F 11 3444 QW 99 SE 4 967 RR EMP SUMM : EMP ID EMP NAME Age Amt Relation 5 E 4 2333 QW 6 F 2 45 RR 1 A 23 67 QW 11 AA 18 45 RR 12 BB 13 45 QW 13 CC 31 7777 QW 14 DD 80 5 QW 15 FF 11 2 RR 17 F 23 89 QW 18 CC 1 1200 QW 36 WW 4 454 RR 36 QG 6 65 RR 22 TB 2 156 RR I need to apply Relation filter to visualization are not changing/applying . 1) More test = var _distDet = DISTINCT(Sheet1[EMP ID _DE] ) //unique Details Ids var _distSumm = DISTINCT('Sheet1 (2)'[EMP ID]) //unique Summary Ids var _commonIDs = INTERSECT(_distDet, _distSumm) //unique Ids found in both tables var _unqDet = COUNTROWS(_distDet) - COUNTROWS(_commonIDs) //count of unique Details Ids not in common table var _unqSumm = COUNTROWS(_distSumm) - COUNTROWS(_commonIDs) //count of unique Summary Ids not in common table RETURN _unqDet //+ _unqSumm 2) More test_Unmatch = var _distDet = DISTINCT(Sheet1[EMP ID _DE] ) //unique Details Ids var _distSumm = DISTINCT('Sheet1 (2)'[EMP ID]) //unique Summary Ids var _commonIDs = INTERSECT(_distDet, _distSumm) //unique Ids found in both tables var _unqDet = COUNTROWS(_distDet) - COUNTROWS(_commonIDs) //count of unique Details Ids not in common table var _unqSumm = COUNTROWS(_distSumm) - COUNTROWS(_commonIDs) //count of unique Summary Ids not in common table RETURN //_unqDet + _unqSumm I do have two visualization More test and More test _Un-Matched ,which are un-match record of each other table. I am trying to apply Slicer but its not applying Properly on visualization , Relationship between table : There is Many to One relationship between the table. Both table have Relation Field ,we can use any one of them to fiter. Expected Result looking for: If I select QW or RR from Slicer it should filter Un-Matched record from More test and Moretest_Unmatch from two different table. For EMP details table: QW Count :5 RR Count: 3 For Emp Summ table: QW Count: 5 RR Count 1 EMP ID EMP NAME Age Amt Relation Vlookup 5 E 4 2333 QW #N/A 13 CC 31 7777 QW #N/A 14 DD 80 5 QW #N/A 17 F 23 89 QW #N/A 18 CC 1 1200 QW #N/A 22 TB 2 156 RR #N/A EMP ID _DE EMP Name_De Age amt Relation Vlookup 2 B 2 45 QW #N/A 3 C 3 2000 QW #N/A 4 D 6 3444 QW #N/A 23 GG 34 6666 QW #N/A 56 A 44 3333 RR #N/A 34 C 16 3555 RR #N/A 41 F 11 3444 QW #N/A 99 SE 4 967 RR #N/A Please can you help on this. Thanks & Regards, Rakesh JadhavHow to apply Slicer filter on un-matching record between two different table.
How to Apply filter to Un-matched records of two different table Hi Team, I have data like this: Emp Details: EMP ID EMP Name Age amt Relation 1 A 1 1000 QW 2 B 2 45 QW 3 C 3 2000 QW 4 D 6 3444 QW 6 F 7 1652 QW 12 CC 12 67 RR 23 GG 34 6666 QW 56 A 44 3333 RR 11 A 12 5555 RR 15 A 14 6666 QW 34 C 16 3555 RR 36 D 56 1333 RR 41 F 11 3444 QW EMP SUMM : EMP ID EMP NAME Age Amt Relation 5 E 4 2333 QW 6 F 2 45 RR 1 A 23 67 QW 11 AA 18 45 RR 12 BB 13 45 QW 13 CC 31 7777 QW 14 DD 80 5 QW 15 FF 11 2 RR 17 F 23 89 QW 18 CC 1 1200 QW I need to apply Relation filter to visualization are not changing/applying . More test = var _distDet = DISTINCT('EMP Details'[EMP ID_DE] ) //unique Details Ids var _distSumm = DISTINCT('Sheet1 (2)'[EMP ID]) //unique Summary Ids var _commonIDs = INTERSECT(_distDet, _distSumm) //unique Ids found in both tables var _unqDet = COUNTROWS(_distDet) - COUNTROWS(_commonIDs) //count of unique Details Ids not in common table var _unqSumm = COUNTROWS(_distSumm) - COUNTROWS(_commonIDs) //count of unique Summary Ids not in common table RETURN _unqDet //+ _unqSumm 1 ) More test = var _distDet = DISTINCT('EMP Details'[EMP ID_DE] ) //unique Details Ids var _distSumm = DISTINCT('Sheet1 (2)'[EMP ID]) //unique Summary Ids var _commonIDs = INTERSECT(_distDet, _distSumm) //unique Ids found in both tables var _unqDet = COUNTROWS(_distDet) - COUNTROWS(_commonIDs) //count of unique Details Ids not in common table var _unqSumm = COUNTROWS(_distSumm) - COUNTROWS(_commonIDs) //count of unique Summary Ids not in common table RETURN _unqDet //+ _unqSumm 2) More test _Un-Matched = var _distDet = DISTINCT('EMP Details'[EMP ID_DE] ) //unique Details Ids var _distSumm = DISTINCT('Sheet1 (2)'[EMP ID]) //unique Summary Ids var _commonIDs = INTERSECT(_distDet, _distSumm) //unique Ids found in both tables var _unqDet = COUNTROWS(_distDet) - COUNTROWS(_commonIDs) //count of unique Details Ids not in common table var _unqSumm = COUNTROWS(_distSumm) - COUNTROWS(_commonIDs) //count of unique Summary Ids not in common table RETURN //_unqDet + _unqSumm This are Un-matched record i have performed via Excel by Vlookup function. I do have two visualization More test and More test _Un-Matched ,which are un-match record of each other table. I am trying to apply Slicer but its not applying on More test _Un-Matched visualization , Please can you help on this. Thanks & Regards, Rakesh JadhavHow to Apply filter to Un-matched records of two different table
Hi Team, I have data like this: Emp Details: EMP ID EMP Name Age amt Relation 1 A 1 1000 QW 2 B 2 45 QW 3 C 3 2000 QW 4 D 6 3444 QW 6 F 7 1652 QW 12 CC 12 67 RR 23 GG 34 6666 QW 56 A 44 3333 RR 11 A 12 5555 RR 15 A 14 6666 QW 34 C 16 3555 RR 36 D 56 1333 RR 41 F 11 3444 QW EMP SUMM : EMP ID EMP NAME Age Amt Relation 5 E 4 2333 QW 6 F 2 45 RR 1 A 23 67 QW 11 AA 18 45 RR 12 BB 13 45 QW 13 CC 31 7777 QW 14 DD 80 5 QW 15 FF 11 2 RR 17 F 23 89 QW 18 CC 1 1200 QW I need to apply Relation filter to visualization are not changing/applying . I have created calculation Like : Is_Using_related11 = IF(ISBLANK(RELATED('EMP Details'[EMP ID_DE])),"blank","Found") Un match_Summ = COUNTROWS(EXCEPT(DISTINCT('Sheet1 (2)'[EMP ID]),DISTINCT('EMP Details'[EMP ID_DE]))) Emp_Age_Details = IF('EMP Details'[Age] >=0 && 'EMP Details'[Age]<=5 ,"0-5" , IF('EMP Details'[Age] >=6 && 'EMP Details'[Age]<=10 ,"6-10",IF('EMP Details'[Age] >=11 && 'EMP Details'[Age]<=20 ,"11-20","31+"))) Combined_Age_Groups = DISTINCT( UNION( SELECTCOLUMNS( //'EMP Details', FILTER('EMP Details', 'EMP Details'[Is_Using_related]= "Blank"), "AgeGroup", FORMAT('EMP Details'[Emp_Age_Details], "") ), SELECTCOLUMNS( 'Sheet1 (2)', "AgeGroup", FORMAT('Sheet1 (2)'[Emp_Age], "") ) ) ) 5. Combined_Age_Groups = DISTINCT( UNION( SELECTCOLUMNS( //'EMP Details', FILTER('EMP Details', 'EMP Details'[Is_Using_related]= "Blank"), "AgeGroup", FORMAT('EMP Details'[Emp_Age_Details], "") ), SELECTCOLUMNS( 'Sheet1 (2)', "AgeGroup", FORMAT('Sheet1 (2)'[Emp_Age], "") ) ) ) Is_Using_related11 and Un match_Summ this two calculations gives Count of Un-matching data from two table. Please can we have any other solutions/Calculation for this,and apply filter to visualization so that values can change in all visualization. Also please let me know how i can attched .pbix file in Community so that you can get proper idea. Thanks & Regards, Rakesh Jadhav
