Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
As you can see here, the sales are divided into 3 groups
My goal is to make my own measure for each group but I do not know how to do it
In the end I want to create a own measure for:
BUD - Sales
IVC - Sales
MFC -Sales
Please help me asap
Best regards,
Tobias
Solved! Go to Solution.
Well, it would most likely look something along the lines of:
BUD Sales = CALCULATE( SUM('Table'[Sales]) , 'Table'[Type] = "BUD" )
IVC Sales = CALCULATE( SUM('Table'[Sales]) , 'Table'[Type] = "IVC" )
MFC Sales = CALCULATE( SUM('Table'[Sales]) , 'Table'[Type] = "MFC" )
Well, it would most likely look something along the lines of:
BUD Sales = CALCULATE( SUM('Table'[Sales]) , 'Table'[Type] = "BUD" )
IVC Sales = CALCULATE( SUM('Table'[Sales]) , 'Table'[Type] = "IVC" )
MFC Sales = CALCULATE( SUM('Table'[Sales]) , 'Table'[Type] = "MFC" )
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |