cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amirabedhiafi
Skilled Sharer
Skilled Sharer

How to test my DAX measures ?

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
1 ACCEPTED SOLUTION
vanessafvg
Super User
Super User

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

4 REPLIES 4
vanessafvg
Super User
Super User

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!




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

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!




All good. Thanks 😄

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!