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.
CS Mix measure is giving total as zero in table, so i have created CS Mix Summ for total value but that is giving wrong total and row level values as zero, can anyone help me with this issue?
CS Mix =
VAR Curr_month =
CALCULATE (
[CS Cont] ,
DATESBETWEEN (
'Calendar'[Calendar date],
[PeriodStart],
[PeriodEnd]
)
)
VAR Pre_month =
CALCULATE (
[CS Cont],
DATESBETWEEN ( 'Calendar'[Calendar date], [PriorPeriodStart], [PriorPeriodEnd] )
)
VAR Pre_month_CS =
CALCULATE (
[Value per CS],
DATESBETWEEN (
'Calendar'[Calendar date],
[PriorPeriodStart],
[PriorPeriodEnd]
)
)
VAR Total_Pre_month_CS =
CALCULATE (
[Value per CS],
ALLSELECTED (),
DATESBETWEEN ( 'Calendar'[Calendar date], [PriorPeriodStart], [PriorPeriodEnd] )
)
VAR Total_Curr_stock =
CALCULATE (
[Total Stock],
ALLSELECTED (),
DATESBETWEEN ( 'Calendar'[Calendar date], [PeriodStart], [PeriodEnd] )
)
VAR Total =
IF (
ISBLANK ( ( Curr_month - Pre_month ) * Total_Curr_stock * ( Pre_month_CS - Total_Pre_month_CS ) ),
0,
( Curr_month - Pre_month ) * Total_Curr_stock * ( Pre_month_CS - Total_Pre_month_CS )
)
RETURN Total
CS Mix Summ =
VAR A2 = ADDCOLUMNS(
SUMMARIZE('Inventory Balance','Inventory Balance'[PlantID],'Inventory Balance'[ProductId]),
"CSMixImpact", CALCULATE([CS Mix] ))
Return SUMX(A2, [CSMixImpact])
CS MIX Impact = [CS Mix] + [CS Mix Summ]
Thanks in advance
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
User | Count |
---|---|
81 | |
76 | |
62 | |
60 | |
48 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |