Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good night Specialists
I turn to you for help because I've tried to fix it on my own but I can't find a way out and the truth is frustrating.
I have the following data model
I strive to star model following the recommendations of many experts, however now I have difficulty getting the results I need for some data.
in the sales table Company each line represents a sale, in the size directory companies are all companies, some of them have no sale, therefore do not have a related fact in the company sales table
I need to get a graph that tells me by segment (field in the company directory table) and by director how many companies do not have sales, the result is as follows:
as noted I do not get the correct result, in addition in the table of the directory companies make an ABC pareto, nor is it filtering correctly with the page filters
I don't know what else to try, if anyone can help me, I appreciate any guidance before I go crazy.
@jcamilo1985 , Try a measure like this
No sales =if(isblank([sales]),1,0)
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |