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 everyone,
I'm trying to build a measure and I want to:
1 get the selected value on a filter ( name of house)
2 use the selected value ti search the category of the house
3 calculate the revenue of the caregory.
so I need to ignore the house selected but at the same time I want it preaviously.
could you please helo me?
Solved! Go to Solution.
Hi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
Revenue: =
SUM( revenue_fact[revenue] )
Revenue Category =
CALCULATE (
[Revenue:],
REMOVEFILTERS ( house_dim[house] ),
VALUES ( house_dim[category] )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
Revenue: =
SUM( revenue_fact[revenue] )
Revenue Category =
CALCULATE (
[Revenue:],
REMOVEFILTERS ( house_dim[house] ),
VALUES ( house_dim[category] )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
119 | |
41 | |
40 | |
28 | |
22 |