cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MP_123 Member
Member

measures doesnt appear

hi all,

 

i'm working with the ssas report

i want to create a new measure, suddenly when i want to calculate with the old measures, it's doesnt appear when i want to use them. measures i can use are the measuer i've been created before in PBI

 

is someone knows what's the problem?

 

thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: measures doesnt appear

Hi @MP_123,

 

According to your description, you want to create a new measure with "old measures". Does these "old measures" means measures created in your data model(either Multidimensional or Tabular)?

 

In Power BI Desktop, when working with SSAS data source, you can only use the objects imported from data source. And the measures you create in Power BI Desktop only return a single value. But the measures in your cube can be sliced by dimension members into rows. You can't see these measure in drop down if you directly use them in DAX because they are multi-value data. You need to use aggregation functions like SUM to make it to be a single value.

 

Capture2.PNG

 

Regards,

 

1 REPLY 1
Moderator v-sihou-msft
Moderator

Re: measures doesnt appear

Hi @MP_123,

 

According to your description, you want to create a new measure with "old measures". Does these "old measures" means measures created in your data model(either Multidimensional or Tabular)?

 

In Power BI Desktop, when working with SSAS data source, you can only use the objects imported from data source. And the measures you create in Power BI Desktop only return a single value. But the measures in your cube can be sliced by dimension members into rows. You can't see these measure in drop down if you directly use them in DAX because they are multi-value data. You need to use aggregation functions like SUM to make it to be a single value.

 

Capture2.PNG

 

Regards,

 

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 33 members 822 guests
Please welcome our newest community members: