Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 |
---|---|
102 | |
68 | |
45 | |
37 | |
36 |