If Condition

Question

if [Dollars paid]<SUM([Claim_line].[Allowed_Amount_B6]) then 'Dollars lost'
elseif [Dollars paid]>SUM([Claim_line].[Allowed_Amount_B6]) then 'Accounts Received'
else 'Outstanding Receivables'
END  --- this Tableau Calculation.

please above calculation how to write the Dax Calculation in power bi?

Comments

Is [Claim_line].[Allowed_Amount_B6] one field or do you want to multiply them?

Answer 1

DAX - I assume [Claim_line].[Allowed_Amount_B6] is one column.

if(table_name[Dollars paid]<SUM(table_name[Claim_line].[Allowed_Amount_B6]) ,'Dollars lost',
if(table_name[Dollars paid]>SUM(table_name[Claim_line].[Allowed_Amount_B6]),'Accounts Received','Outstanding Receivables'))

Comments

TableA= SUM(Paid), SUM(Patient Respons Amount)

TableB= SUM(Allowed Paid)

i written dax - measure calculation get solution but i need filter level measure calculation it is not working.

Actually these are two fields P=Paid+Unpaid and Allowed Paid

Allowed Paid=p then "Paid"
Allowed Paid<P then "Under"
Allowed Paid>P then "Over"

how to write DAX Calculation in Column or Measure? please detail? below example:

Allowed Paid  p(Paid+Patient Respons amount)

120                      20+30(50) = 120<50=Under

150                     130+100(230) = 150>230 =Over

200                     140+60(200)=200=200= Paid             finally_Filter(Paid,Under,Over)

---

Hi, Vnk. Check out the solution below.

If you want to add = 7 to Under or Over, then add as below. Depending on whether =7 be assigned to Under or Over.

IF([Table name][Allowed Paid] <=p,"Under","Over") 

#or

IF([Table name][Allowed Paid] <p,"Under","Over")

Else check for =7 condition using nested if.

IF([Table name][Allowed Paid] <p,"Under",IF([Table name][Allowed Paid] >p,"Over","Equal to 7"))

Hope it helps! 

Revert back if any problems.

PS: Do Signup to the community, it will help you get email notifications and keep you updated with new discussions on the Community :)

---

Hi Vnk,

Dax would work if p is a column. Then you can use the below DAX itself.

IF([Table name][Allowed Paid] <p,"Under",IF([Table name][Allowed Paid] >p,"Over","Paid"))

As per your example, p value changes for each row, So it should be a column and not a measure. Change p to a column and try again.

Hope you understood.

PS: Do Signup to the community, it will help you get email notifications and keep you updated with new discussions on the Community :)

---

Hi

1) How to deploy the report to Power Bi Report server?

2) i have 5 visualization and 1 tabular model in One Page so i need to export in to pdf all visualization and 1 tabular model. how to get this one?

---

Hi @Vnk,

For saving the report in Power bi server.

I've not tried it anytime, but I hope might help. Visit this page for more information.

https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report

To export as a pdf, Export it PDF is available in the Power BI file tab.

It will,create a pdf of the report.