cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ygandhi1 Frequent Visitor
Frequent Visitor

Calculate measure for specific type grouping

Hi,
I want to create a calculated measure. My data is live connected to ssrs so I cannot create a calculated column nor I can select and group.

I have 3 tables: Account which has a field Account name
Sales which has a field sales person (it has all the name and also has a value unknown and blank)

I want to find out if the Accounts has a sales person associated with it then it should show Available
But if the Account name has unknown or blank associated with it then show unavailable.

Thank you in advance.
2 REPLIES 2
Ygandhi1 Frequent Visitor
Frequent Visitor

Re: Calculate measure for specific type grouping

Correction: I have 2 tables

P. S I am very new to power BI.
Microsoft v-huizhn-msft
Microsoft

Re: Calculate measure for specific type grouping

Hi @Ygandhi1,

Yeah, there are some limiations live connected to ssrs, we can't create measure and calculated column. You'd better use import model. Or you create a viusal, add all the needed data into the table. Then export the data into csv file, open another .pbix file and upload the data from csv file, and create measure and calculated column there.

I want to find out if the Accounts has a sales person associated with it then it should show Available
But if the Account name has unknown or blank associated with it then show unavailable.


It's hard to post detailed solution without sample table. If there is relationship between the table? You'd better share the sample table and list expected result for further analysis.

Best Regards,
Angelia

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,308)