Forum Discussion
Suma
7 years agoRegular Visitor
Using Calculated Measure as a value in a Line Chart
Hi All, I am new to Power BI, learning basics to migrate from excel to BI. I've the data (history of Incidents from April) coming up from Excel which is in a Table (Incident_AO). 2 columns of...
Suma
7 years agoRegular Visitor
Maggie - Thanks so muh for your response first of all. Just to update you....
10/26/2018 355 (Table 2) -> Practically this is the extract from Service now with more than 20 columns and count of 355 is not straight forward. This count is based on some filters applied. Like column 10= "abc", Column 8="xyz" etc.
Did you asked me to write a measure in the "table 2" OR a "new table" with a measure below?
new = DISTINCT(UNION(Incident_AO,table2))
Please clarify.
v-juanli-msft
7 years agoCommunity Support
Hi Suma
write a formula to create a "new table".
new table= DISTINCT(UNION(Incident_AO,table2))
Best Regards
Maggie