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
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)