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.
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 =
@ManuApo ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
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 =
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |