Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |