Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hello community,
I am struggling to create few measures with the same end point, hopefully someone can help me.
I have a dimension calendar table with a relationship to my fact table. I have a date slicer that I use to filter my visuals.
I want to create 4 measures based on 4 measures that I have already created where basically removes the date filter slicer but keeps the year i.e. in this case all rows for 2022
Any suggestions??
Attached is a screenshot:
Solved! Go to Solution.
Hi @ALLUREAN and @amitchandak
this is not working. But I finally got it working doing this!!!!
Measure 1 =
Hi @amitchandak ,
The date slicer on top of the screenshot (where it says period) , is filtering the 4 measures that are on the table. That is giving me the desired results.
On the other hand I want to create 4 new measures that removes the filter used in the slicer (
It must be something like this....
Measure 1 =
CALCULATE( SUM('Fact'[GNWP]) ,
Hope it makes it more clear now,
Thank you so much!!
Manu
Hi, @ManuApo
Try this:
Measure 1 =
CALCULATE( SUM('Fact'[GNWP]) ,
Proud to be a Super User!
Hi @ALLUREAN and @amitchandak
this is not working. But I finally got it working doing this!!!!
Measure 1 =
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
67 | |
65 | |
42 | |
42 |
User | Count |
---|---|
46 | |
38 | |
28 | |
26 | |
26 |