Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I created a measure to take the sum of a projects cost & multiply it by 6% as that is the tax cost. So I have the below:
TaxCost = iferror(calculate(sum('Projects'[Amount]))*.06,0)
Now in matrix the rows I have the projects & under that I have them broken down to a lower level to show what makes up those costs. Is there a way I can assign the measure TaxCost to one of the lower levels. For example line items are:
Project:
NYC
Cost of Material = $100,000
Labor = $10,000
Tax Cost = (Blank)
Will be extremely helpful it is possible to assign this measure to Tax Cost.
Solved! Go to Solution.
Hi @PeteSil ,
I created some data:
Do you want to specify a certain level in the matrix to implement the operation?
You can use the IF + Hasonvalue function to make a hierarchical judgment
HASONEVALUE function (DAX) - DAX | Microsoft Learn
IF function (DAX) - DAX | Microsoft Learn
Measure =
IF(
HASONEVALUE('Table'[Group3]),3, // Group3
IF(
HASONEVALUE('Table'[Group2]),2, // Group2
IF(
HASONEVALUE('Table'[Group1]),1, //Group1
0)))
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @PeteSil ,
I created some data:
Do you want to specify a certain level in the matrix to implement the operation?
You can use the IF + Hasonvalue function to make a hierarchical judgment
HASONEVALUE function (DAX) - DAX | Microsoft Learn
IF function (DAX) - DAX | Microsoft Learn
Measure =
IF(
HASONEVALUE('Table'[Group3]),3, // Group3
IF(
HASONEVALUE('Table'[Group2]),2, // Group2
IF(
HASONEVALUE('Table'[Group1]),1, //Group1
0)))
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi there,
I have a similar requirement in that I have a measure to calculate Shipping Income as a % of the sum of the sales value of different products sold in the month.
I would like the £19K circled in blue to be reflect as a single value in the cell circled in red ie Shipping Income under Other Sales Category.
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |