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.
Hi there,
I want to calculate cumulative signups for current FY & last FY. FY starts on 1st July & ends on 30th June.
I created a measure to calculate cumulative total for current FY, but it is incorrect. should be 15 in Aug instead of 14. Please let me know what is wrong with this measure and also provide a measure to calculate cumulative signups for last FY (FY22)
Here is the pbi file : https://1drv.ms/u/s!Ag919_pO_UKrghrxssJ1dthLEMvu?e=q2183a
many thanks!
Solved! Go to Solution.
Hi,
Thank you for your message.
Could you please check the attached pbix file, if it shows the correct numbers?
Thanks.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure if I understood your question correctly, but I think ID = 111 is in both Jul and Aug (Duplicated).
So, I think if the measure distinctcount IDs, it is the correct number.
However, If you still want to show 15, even ID=11 is shown in the both months, please try the below measure.
Signups Current FY_Cum =
VAR _newtable =
ADDCOLUMNS (
SUMMARIZE (
FILTER (
ALL ( Datedim ),
Datedim[Date] <= MAX ( Datedim[Date] )
&& Datedim[Is Current FY] = 1
),
Datedim[FYYear],
Datedim[FY_Monthname],
Datedim[FYMonthNum]
),
"@singup", CALCULATE ( DISTINCTCOUNT ( 'Table'[Id] ) )
)
RETURN
SUMX ( _newtable, [@singup] )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
thanks @Jihwan_Kim , Would you please also let me know how can I calculate cumulative for last FY (FY22). I can't use the filter Datedim[Is Current FY] <>1 as in my dataset there is data from FY21 as well ?
Hi,
Thank you for your message.
Could you please check the attached pbix file, if it shows the correct numbers?
Thanks.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |