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 had a dataset see the top part in below, and i want to achieve the calculation/measure in below. please help. thanks.
Solved! Go to Solution.
Hi @Anonymous,
Here are the measures:
Total Active = CALCULATE ( COUNT ( 'Table'[Customer] ), FILTER ( ALL ( 'Table'), 'Table'[Sign Up Date] <= MAX ( 'Table'[Sign Up Date] ) && 'Table'[Status] = "Active" ) ) Cancelled Today = IF ( MAX ( 'Table'[Status] ) = "Cancelled", 1, 0 ) Cancelled % in Today = DIVIDE ( [Cancelled Today], [Total Active], 0 )
Here is the screenshot:
Kindly accept my answer as solution if i have solved your problem. Also, don't forget to hit the thumbs up.
Prateek Raina
Its not hard but you need to understand how PowerBI works and some simple dax but some complex concepts. First and foremost you need a date table or other table of unique sequential values) to take advantage of DAX Time Intelligence so you can do Cumulative functions Can't really take the time to explain so here is an example.
https://1drv.ms/u/s!AuCIkLeqFmlhhJh3pj3q9XzrxpxAng
Hi @Anonymous,
Here are the measures:
Total Active = CALCULATE ( COUNT ( 'Table'[Customer] ), FILTER ( ALL ( 'Table'), 'Table'[Sign Up Date] <= MAX ( 'Table'[Sign Up Date] ) && 'Table'[Status] = "Active" ) ) Cancelled Today = IF ( MAX ( 'Table'[Status] ) = "Cancelled", 1, 0 ) Cancelled % in Today = DIVIDE ( [Cancelled Today], [Total Active], 0 )
Here is the screenshot:
Kindly accept my answer as solution if i have solved your problem. Also, don't forget to hit the thumbs up.
Prateek Raina
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |