Forum Discussion

SSWADOOD's avatar
SSWADOOD
Icon for Helper I rankHelper I
4 years ago

SUM BASED ON AMOUNTS RANGES

I need help with some dax measures, currently i have a table with gross_premium of policies  which divided by classes of pool and non pool First i wanted to get sum of premium of each policy ...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi SSWADOOD 

 

I am a little bit lost, what is your desired result? Something like this? Changed the Policy_NO as I had to type all the data...

gp_status_sum = 
VAR CurStatus = SELECTEDVALUE('Status'[Status])
RETURN
IF([GPLEVEL]=CurStatus,[GPSUM])

 

 

SSWADOOD's avatar
SSWADOOD
Icon for Helper I rankHelper I
4 years ago

changed the measure, displays the correct results in table visual but blank in card visual

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi SSWADOOD 

     

    I am not sure what went wrong, I got the dummy data, Pool and Status are two disconnected table, in the table visual there is column from Pool table, then the Card is showing the total...would you like to send me a sample .pbix file? I can message you my email address