Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
ladislaocsulak
Frequent Visitor

Registers considered in DAX measure

Hello,

 

I have a doubt about DAX measures. Is there a way in which I can view the registers that are counting certain measure?

For example, I have created the next measure that counts sales of the last 30 days and it says it is 33 sales.

sales_quantity_last_30_days = CALCULATE(DISTINCTCOUNT(sales[id]),DATESINPERIOD ( Calendario[Date], TODAY(), -30, DAY ))

 

Is there any way in which I can access directly to those specific 33 registers to see that data?

 

I upload a dummy table with a source table and the measure:

https://drive.google.com/drive/folders/1TOYezhAuiy0ADTNcKVL1ayNw5XoLMo_I?usp=sharing

 

Thanks in advance!

1 ACCEPTED SOLUTION
DimaMD
Solution Sage
Solution Sage

Hi @ladislaocsulak Explain what registers are?
You have not tried to create a simple table and reflect the id_buyer and your measure


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

View solution in original post

2 REPLIES 2
ladislaocsulak
Frequent Visitor

Adding the measure to a table solves the problem. Thank you!

DimaMD
Solution Sage
Solution Sage

Hi @ladislaocsulak Explain what registers are?
You have not tried to create a simple table and reflect the id_buyer and your measure


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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