Forum Discussion

powerbiwork's avatar
powerbiwork
Helper I
4 years ago

DAX Measure from Switch Measure Not Totaling

Hi, 

 

I created a switch measure for a couple of conditions to pull a specific value. Then I use that to create another measure to multiply by a column to get the value I need. However, the total would not show up and I have tried to use sumx and summarize the table but the total was still wrong. Any help will be much appreciated. 

 

Here is my switch value, which worked and pulls correctly

I need to use whatever rate that pulls to create another measure 

Which calculated correctly, however, does not sum 

 

Thanks.