cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Controller_CVL
Frequent Visitor

status count with measures

I need help with something that can be simple, basically I have a measure that returns a certain status, increased, decreased or sporadic, this measure does not use column information but the result of other measures to determine its final value, so I don't I can only do a count because it returns an error, I have an idea that I must use a virtual table and do a count with a filter, however it only returns the total amount, it does not return the status I selected, and that's what I need help with , see attached image.

 

Controller_CVL_0-1660853954644.png

 

 

4 REPLIES 4
onurbmiguel_
Super User
Super User

Hello Controller_CVL

 

May i sugest to use "summarize" to create a virtual table and then make your calculation.

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


I've already done it this way, but it's only returning the total value and not the value I asked for in the filter.

Hi again, 

Please share an example with some data , so i can understand what you want.

 

BR 

Bruno

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


'Cliente Pagador' = fact table origin

the others are formed by measures

the column under discussion is Result

because it depends on the other columns made by measurements to arrive at a result, I just want to calculate the amount of each result, for example, 30 'aumentou', 20 'diminuiu' and so on.

I can't share the data because it's too big, the file has about 40 tables from different sources and it would be difficult to split without compromising the data I want to send.

 

 

Controller_CVL_0-1660921305014.png

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors