Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
newbie9292
Helper II
Helper II

The total sum of my measure column is showing 0

Hello,
I am trying to write a dax measure which takes a parameter input and uses this input to calculate the new value. The calculation works on the row level but for some reason I get 0 in the total.

newbie9292_0-1676455138293.png

Here's the dax for my calculation : 

Custom_Gewichtet_Betrag =
VAR ScenarioCategory = [Scenario Category Measure]
VAR Betrag = SUM('MyTable1'[Betrag])
VAR OGchance= VALUE(AVERAGE('MyTable2'[Chance in %]))
VAR ThresholdHigh = VALUE(InputHigh[InputHigh Value])
VAR ThresholdLow = VALUE(InputLow[InputLow Value])
VAR CustomHighChance = VALUE('Custom Chance High'[Custom Chance High Value])
VAR CustomMedChance = VALUE('Custom Med Chance'[Custom Med Chance Value])
VAR CustomLowChance = VALUE(Custom_Chance_Low[Custom_Chance Value])
RETURN
SWITCH(TRUE(),
INT(OGchance) <= INT(ThresholdLow), Betrag*(CustomLowChance/100),
INT(OGchance) >= INT(ThresholdHigh), Betrag*(CustomHighChance/100),
INT(OGchance)>INT(ThresholdLow)&& INT(OGchance)<INT(ThresholdHigh),Betrag*(CustomMedChance/100)
)


Can someone please help me figuring out the issue?

 

 

 

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.