How to filter on multiple columns in single table

0 votes
i have one requirement:

list of columns like(Reason1,Reson2,.....,Name,Calimid,Patient)

i have 10 columns(Reason1, Reason2,Reason3,Reason4........)  in single table. but conditions  reason1 =2 , for the claimid count or claimid values. i want show only 2 for all 10 columns.

Note: we need to show only Reason 2 claimid list,plz create any dax cal?
Jul 9 in Power BI by vnk
153 views
Are you saying you want to show only reason 2 and claim id whose reason 1= reason 2?
ex: Reason1 (1, 253,22,25,444,5,6)

     Reason2(22,5,253,90,567,346,1,34)

     Reason3(345,890,34,2,33,45,22,56)

     -----10 etc.

output: submittedclaimid,Reasoncode,SUM(Amount)

             12xvr,22,345

             2341,22,800

             2385xi,22,500

-------etc
Is amount also a column in your table?

You want to show sum of amount and distinct claimid for evry reason code in reason 2 column? Is this your question?
Yes. but we need to previous example of output.

1 answer to this question.

0 votes

I used dummy data to show how to get the output like yours.

Dummy Data -  I took 4 Reasons to create a table.

Now Load the data into Power BI.

Then Click on All reason columns and click on unpivot columns to collect all reason codes in one Reason columns and Reason Codes field.

Like below - 

Apply and close the editor, Go to Power BI Desktop. Follow below steps:

1. Select table from Visualizations.

2. Select Reason codes, Claim_id and amount columns.

3. Click on arrow button next to Reason codes and select Dont Summarize instead of Sum.

4. The table will be shown as below.

answered Jul 10 by sindhu
Do you want to remove many to many relationship between tables?
No,we need to find the many to one relationship.but the count is matching for payers.

Hi, you can refer to this blog to deal with many to many and with many to one relationships.

https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships

I do not know much about Many to many relationships in Power BI. It might help you.

thanks for your reply. NEw requirement:

i have one table, in table columns contains Master,claimid,billed,paid,servicecode,reasoncodeA1,AmountA1,quanityA1,,...etc we have 9 reasoncoden,Amountn,Quantityn coumns data available. see below columns

Master,Claimid,billed,Paid,servicecode,reasoncodeA1,AmountA1,QuantityA1,ReasoncodeA2,AmountA2,QuantityA2,ReasoncodeA3,AmountA3,QuantityA3,ReasoncodeB1,AmountB1,QuantityB1,ReasoncodeB2,AmountB2,QuantityB2,ReasoncodeB3,AmountB3,QuantityB3,ReasoncodeC1,AmountC1,QuantityC1,ReasoncodeC2,AmountC2,QuantityC2,ReasoncodeC3,AmountC3,QuantityC3.

123,10160623,400,200,Hv:2309,45,100,2,125,120,3,null,-120,4,22,10,1,125,400,20,null,null,null,2,null,1,45,100,2,16,1000,4

234,10160645,500,600,sv:28902,16,100,2,null,120,3,2,-120,4,125,10,1,45,400,20,46,200,null,16,null,1,167,100,2,35,1000,4------50 rows

example_output: Reasoncode by Claimidcount

we need Reasoncodes,Claimid

Null ,   10160623,10160645          

45 ,10160623 

125,10160623,10160645

22,10160623

2 ,10160623,10160645

16,10160645,10160623

167,10160645

 35 ,10160645 

46,10160645           

in power bi how to combine multiple columns in to single column, we do unpivot ..etc.

can you please correct answer.                 

Your question is converted as a new question. Kindly visit the below link.

https://www.edureka.co/community/52199/how-to-combine-multiple-columns-in-to-single-column

Related Questions In Power BI

0 votes
1 answer

how to combine multiple columns in to single column?

1. Select Edit Queries 2.Select which column you ...READ MORE

answered Aug 6 in Power BI by anonymous
58 views
0 votes
1 answer

How to create final table based on Joins of two tables in power BI?

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1 in Power BI by Cherukuri
• 25,900 points
133 views
0 votes
1 answer

How to combine multiple tables in power BI?

Hi Sindhu, You can merge the 3 tables ...READ MORE

answered Mar 14 in Power BI by Cherukuri
• 25,900 points
794 views
0 votes
1 answer

How to add multiple reference lines on a bar/ column graph?

Hi, Follow below steps: 1. Add a bar/ column ...READ MORE

answered Mar 26 in Power BI by Cherukuri
• 25,900 points
114 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

answered May 17 in Power BI by Avantika
• 1,500 points

edited May 17 by Omkar 76 views
0 votes
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 14,070 points
2,263 views
0 votes
1 answer

Select Columns from table instead of removing afterwards in Power Query

Try this. let db = Sql.Databases("sqlserver.database.url"){[Name="DatabaseName"]}[Data], Sales_vDimCustomer = ...READ MORE

answered Oct 31, 2018 in Power BI by Shubham
• 13,290 points
195 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27 in Power BI by Phalguni
• 1,010 points
76 views
0 votes
1 answer

How to Install Power BI in Windows

Hi, Anitha Go to this Link https://powerbi.microsoft.com/en-us/downloads/ Then click on ...READ MORE

answered Feb 28 in Power BI by Cherukuri
• 25,900 points
32 views
0 votes
1 answer

How to open hyperlink in the same tab in power BI

Hey, the discussion on this topic is ...READ MORE

answered Jul 10 in Power BI by anonymous
• 25,900 points
166 views