The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am using a measure to represent either column A (Real) or column B (Escenario) for each month switching over the selected month.
The representation in the month columns works fine, but the calculated Total is the sum of the whole Column A (Jan-Dec) instead of the sum of each represented column (Jan - Oct Column A + Nov- Dec Column B)
Is there any way I can achieve the sum of (Jan - Oct Column A + Nov- Dec Column B)
Thank you!
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.
I hope the below can provide some ideas on how to create a solution for your semantic model.
Expected result measure: =
SUMX (
VALUES ( 'Calendar'[Year-Month sort] ),
IF (
CALCULATE ( MAX ( 'Calendar'[Year-Month sort] ) )
<= MAX ( 'Slicer calendar'[Year-Month sort] ),
CALCULATE ( SUM ( Data[Real] ) ),
CALCULATE ( SUM ( Data[Scenario] ) )
)
)
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.
I hope the below can provide some ideas on how to create a solution for your semantic model.
Expected result measure: =
SUMX (
VALUES ( 'Calendar'[Year-Month sort] ),
IF (
CALCULATE ( MAX ( 'Calendar'[Year-Month sort] ) )
<= MAX ( 'Slicer calendar'[Year-Month sort] ),
CALCULATE ( SUM ( Data[Real] ) ),
CALCULATE ( SUM ( Data[Scenario] ) )
)
)
User | Count |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
14 | |
14 | |
9 | |
7 |