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 Guys,
I am creating a model where I have to allocate admin cost between two departments. So I have deparmtent mapping which allows me to create a slicer and look at the cost of each department individually. I have created measures through which I can see the allocated cost i.e. Sales Cost = (Sales+(50% Admin))
Now I want the same functionality through slicers. So when I select let's say Sales & Admin, the cost being shown in the pivot is the total cost. Whereas, I want to see "Total Sales cost" & "50% Admin cost".
Solved! Go to Solution.
Hi @zubairs ,
You can create a measure like this to calculate:
Re =
VAR _sum =
CALCULATE ( SUM ( 'Table'[Values] ), 'Table'[Department] = "KSA Sales" )
+ 0.5
* CALCULATE ( SUM ( 'Table'[Values] ), 'Table'[Department] = "KSA Branch Admin" )
RETURN
IF (
HASONEVALUE ( 'Table'[CE mapping] ),
[Last Year],
IF ( HASONEFILTER ( 'Table'[Department] ), [Last Year], _sum )
)
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @zubairs ,
You can create a measure like this to calculate:
Re =
VAR _sum =
CALCULATE ( SUM ( 'Table'[Values] ), 'Table'[Department] = "KSA Sales" )
+ 0.5
* CALCULATE ( SUM ( 'Table'[Values] ), 'Table'[Department] = "KSA Branch Admin" )
RETURN
IF (
HASONEVALUE ( 'Table'[CE mapping] ),
[Last Year],
IF ( HASONEFILTER ( 'Table'[Department] ), [Last Year], _sum )
)
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |