The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello
I have a matrix (below) and the Churn is calculated using the measure of:
Solved! Go to Solution.
@Anonymous
Churn Measure Total =
VAR __Table = SUMMARIZE('Table',[CustomerReference],"__Churn",[Churn])
RETURN
IF(HASONEVALUE('Table'[CustomerReference]),[Churn],SUMX(__Table,[__Churn]))
@Anonymous
Churn Measure Total =
VAR __Table = SUMMARIZE('Table',[CustomerReference],"__Churn",[Churn])
RETURN
IF(HASONEVALUE('Table'[CustomerReference]),[Churn],SUMX(__Table,[__Churn]))