Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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.
Regards,
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.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |