Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Have some problems with measures
1. Wrong divide so 22670/21 = 1 079.52, but measure % = divide([5],[6000]) return 119747,48
2. measure % = divide([5],[6000]) return 119747,48 % but should return 1197,47 % like measure Marge, but something went wrong, all measure is same
measure 5 = CALCULATE(
sumx(Table1, [SUM_CRE]-[SUM_DEB]),
FILTER(CodeTable,left([sas_kod],1)="5"))
measure 6 = CALCULATE(
sumx(Table1, [SUM_CRE]-[SUM_DEB]),
FILTER(CodeTable,left([sas_kod],1)="6"))
measure 6000 = CALCULATE(
sumx(Table1, [SUM_CRE]-[SUM_DEB]),
FILTER(CodeTable,left([sas_kod],4)="6000"))
measure [BP] = [5]-[6]
Hi @Analitika ,
Unfortunatly,I don't know your data model. Using your measure works well in my test file. If the problem still exists, can you tell me your data model so that I can do more tests.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
15 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
29 | |
3 | |
3 | |
2 | |
2 |