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 there,
I'm trying to replicate the following calculation to achieve a conditional sum measure based on a column value from a related table. I need this to me a measure as opposed to a calculated column.
From my understanding, IF statements can only filter based on a measure value as opposed to a column value.
Ex logic:
If Category[Category] = X then Sum(Sales[SalesX]) else
If Category[Category] = Y then Sum(Sales[SalesY]) else
If Category[Category] = Z then Sum(Sales[SalesZ]) else 0
The goal is to be able to slice by Category and see the the related Sales Amount.
Any ideas how this can be accomplished?
Thanks!
Excel Power Pivot: add column 'Sales X/Y/Z' to tabel 'Sales', the formula as below:
use min or max column value.
Power BI Desktop use a measure:
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |