Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
amirabedhiafi
Impactful Individual
Impactful Individual

How to test my DAX measures ?

‎01-23-2022 05:05 AM

I am creating different DAX measures based on the data coming from a an SSAS tabular model.

The data pushed into the SSAS tabular model is coming from  Hive and Oracle databases.

To validate each measure, should I build the hive or PL-SQL queries to make sure that my DAX measures are giving me the correct result ?

 

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini
Message 1 of 5
1,243 Views
1 ACCEPTED SOLUTION
vanessafvg
Super User
Super User

‎01-23-2022 07:00 AM

whatever your source is i would write the measures / aggregations against your source  or if you have a report somewhere that already uses those measures you can use that too, as long as you know its been validated.

 

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




View solution in original post

Message 2 of 5
1,196 Views
0
4 REPLIES 4
vanessafvg
Super User
Super User

‎01-23-2022 07:00 AM

whatever your source is i would write the measures / aggregations against your source  or if you have a report somewhere that already uses those measures you can use that too, as long as you know its been validated.

 

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Message 2 of 5
1,197 Views
0
amirabedhiafi
Impactful Individual
Impactful Individual
In response to vanessafvg

‎01-23-2022 07:03 AM

I don't have any related reports/measures / aggregations against my sources, I am currently using the Oracle PL-SQL queries to validate the measures results.

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini
Message 3 of 5
1,195 Views
vanessafvg
Super User
Super User
In response to amirabedhiafi

‎01-23-2022 07:20 AM

that should be fine then as long as you know the correct way to test,  is there anything else you are concerned about?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Message 4 of 5
1,192 Views
0
amirabedhiafi
Impactful Individual
Impactful Individual
In response to vanessafvg

‎01-23-2022 07:22 AM

All good. Thanks 😄

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini
Message 5 of 5
1,191 Views

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All
Top Solution Authors
View All