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.
There is one customer column as CUST_CODE which we want to create a calculated column which has the customer value which is filtered based on the REVENUE column.
Basically we want just those customers which has revenue. So want to create a calculated column.
I am using this formula and getting the error.
=CALCULATE(VALUES(FACT_SALES[CUST_CODE]),[Revenue]<>blank())
the folowing calculated column returns TRUE for the customers that made revenue.
=
NOT ISBLANK (
CALCULATE (
SUM ( ACT_SALES[Revenue] ),
ALLEXCEPT ( FACT_SALES, FACT_SALES[CUST_CODE] )
)
)
Thank you @tamerj1 ,
I think I have failed to mention REVENUE is a measure which calculates total Revenue.
Customer is a dimension column.
So based on this I want a calculated column of show customers where REVENUE is not blank.
I understand it is a measure but I guessed it is a sum of a column. However, you can use
=
NOT ISBLANK (
CALCULATE ( [Revenue], ALLEXCEPT ( FACT_SALES, FACT_SALES[CUST_CODE] ) )
)
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |