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.
Hello,
I am getting an incorrect total for my measure. Please see below for the details of my measure.
Hi,
Share the download link of the PBI file.
write another measure like this
SUMX ( VALUES('table'[category Name]), [Increase Sale]
@Abrar786 , Try two measures like
Inc =COUNTROWS (
FILTER (
'category',
[@SaleDiff] >= 'category'[category min value]
&& [@SaleDiff] < 'category'[category max value]
)
)
Increase Sale =
Sumx(FILTER (
ADDCOLUMNS (
values ( invoices_details[customer_no] ),
"@CYSale", [Total Sale],
"@LYSale", [LY Sale],
"@SaleDiff", [Total Sale] - [LY Sale]
),
[@CYSale] > 0
&& [@LYSale] > 0
&& [@CYSale] > [@LYSale]
&& [Inc]> 0
),[@SaleDiff])
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 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |