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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Each line quantity 1

Question about concept: Each row of my table represents quantity = 1, create a custom column  "Quantity = 1" is correct? If I don't do this, there is no way to go forward.

 

Tks

1 ACCEPTED SOLUTION
Phil_Seamark
Employee
Employee

Hi @Anonymous, yes you can add custom columns such as this.  It can be done easily in the Query Editor or in DAX.

 

This can be useful to SUM to get numbers that represent Counts.

 

You can also do this using calculated measures using the COUNTROWS function, but it depends on how confident you are with creating DAX measures.  If you have a particular issue you are trying to solve, post more about it here and we will do our best to help you.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

1 REPLY 1
Phil_Seamark
Employee
Employee

Hi @Anonymous, yes you can add custom columns such as this.  It can be done easily in the Query Editor or in DAX.

 

This can be useful to SUM to get numbers that represent Counts.

 

You can also do this using calculated measures using the COUNTROWS function, but it depends on how confident you are with creating DAX measures.  If you have a particular issue you are trying to solve, post more about it here and we will do our best to help you.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.