Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Need help to reflect filters/slicer value in Measure
No.of Payments = CALCULATE(COUNT('tstData'[Pay_Amt]),ALLEXCEPT('tstData','tstData'[ID],'tstData'[Name]),'tstData'[Pay_Date] in ALLSELECTED('tstData'[Pay_Date]))
No.of Payments values to be adjusted, based on date slicer values
Sample Data
ID,Name,Pay_Type,Pay_Amt,Pay_Date
1,Name 1,ABC,102.65,8/1/2020
1,Name 1,BCD,2001.14,8/11/2020
1,Name 1,CDE,234.5,8/13/2020
1,Name 1,DEF,102.65,9/1/2020
1,Name 1,EFG,1023.43,9/5/2020
1,Name 1,FGH,23.47,9/15/2020
1,Name 1,GHI,2054.78,10/1/2020
1,Name 1,HIJ,3468.01,10/15/2020
2,Name 2,ABC,703.65,8/1/2020
2,Name 2,BCD,1101.25,8/11/2020
2,Name 2,CDE,3424.5,8/13/2020
2,Name 2,DEF,1702.65,9/1/2020
2,Name 2,EFG,103.43,9/5/2020
2,Name 2,FGH,236.47,9/15/2020
Solved! Go to Solution.
@Rajamanikandan assume slice comes from a date table, which have a one to many relationship between 'DateTable'[Date] and 'tstData'[Pay_Date]. then try this code
No.of Payments = CALCULATE(COUNT('tstData'[Pay_Amt]),ALL('tstData'),VALUES('tstData'[ID]),VALUES('tstData'[Name]),'tstData'[Pay_Date] IN ALLSELECTED('DateTable'[Date]))
'DateTable'[Date]
@Rajamanikandan assume slice comes from a date table, which have a one to many relationship between 'DateTable'[Date] and 'tstData'[Pay_Date]. then try this code
No.of Payments = CALCULATE(COUNT('tstData'[Pay_Amt]),ALL('tstData'),VALUES('tstData'[ID]),VALUES('tstData'[Name]),'tstData'[Pay_Date] IN ALLSELECTED('DateTable'[Date]))
'DateTable'[Date]
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
43 | |
26 | |
21 |