Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a Opening Count Measure (Given Below). The Logic which I have applied is:
If you looking for the Opening Count for Jan-2017 then Merge1[Loggd_dt] should be before 01 Jan 2017 and Merge1[Cmplt_dt] values should be from 01 jan 2017 (The data is from year 2005 upto date and the logic is to be applied to overall data). I am taking this measure in a matrix(along with two other measures). I have also applied some slicer in the same page. My other two measures are changing according to the value selected in Slicer. But the measure given below is not changing according to slicer.
Opening Count = IF ( HASONEVALUE ( DateTable[StartOfMonthDate] ), CALCULATE ( [Count_rows], FILTER ( ALL ( Merge1 ), ( Merge1[LOGGD_DT] < CALCULATE ( VALUES ( DateTable[StartOfMonthDate] ), USERELATIONSHIP ( DateTable[Date], Merge1[LOGGD_DT] ) ) && Merge1[CMPLT_DT] >= CALCULATE ( VALUES ( DateTable[StartOfMonthDate] ), USERELATIONSHIP ( DateTable[Date], Merge1[CMPLT_DT] ) ) ) ) ) )
Closed Count = CALCULATE ( [Count_rows], USERELATIONSHIP ( DateTable[Date], Merge1[CMPLT_DT] ), Merge1[STATUS] = "CL" )
InProcess Count = CALCULATE ( [Count_rows], USERELATIONSHIP ( DateTable[Date], Merge1[LOGGD_DT] ) )
Count_rows = COUNTROWS(Merge1)
Please help me with the same.
Solved! Go to Solution.
Hi @Sonal27,
Please replace ALL with ALLSELECTED in measure [opening Count].
Opening Count = IF ( HASONEVALUE ( DateTable[StartOfMonthDate] ), CALCULATE ( [Count_rows], FILTER ( ALLSELECTED ( Merge1 ), ( Merge1[LOGGD_DT] < CALCULATE ( VALUES ( DateTable[StartOfMonthDate] ), USERELATIONSHIP ( DateTable[Date], Merge1[LOGGD_DT] ) ) && Merge1[CMPLT_DT] >= CALCULATE ( VALUES ( DateTable[StartOfMonthDate] ), USERELATIONSHIP ( DateTable[Date], Merge1[CMPLT_DT] ) ) ) ) ) )
Best regards,
Yuliana Gu
Hi @Sonal27,
Please replace ALL with ALLSELECTED in measure [opening Count].
Opening Count = IF ( HASONEVALUE ( DateTable[StartOfMonthDate] ), CALCULATE ( [Count_rows], FILTER ( ALLSELECTED ( Merge1 ), ( Merge1[LOGGD_DT] < CALCULATE ( VALUES ( DateTable[StartOfMonthDate] ), USERELATIONSHIP ( DateTable[Date], Merge1[LOGGD_DT] ) ) && Merge1[CMPLT_DT] >= CALCULATE ( VALUES ( DateTable[StartOfMonthDate] ), USERELATIONSHIP ( DateTable[Date], Merge1[CMPLT_DT] ) ) ) ) ) )
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |