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
EndriuBlack
Frequent Visitor

My measure doesn't calculate well

Hello,

I have got this problem, 

I'm fighting with this issue for few days and I decided to ask The Community couse I don't understand the problem.

 

So,

I try to count number of industries that have two characteristics,

My measure looks like this:

 

Liczba firm wg par CD v2 =
     VAR paramWP = 'Param WP v2'[Wartość Param WP v2]
     VAR paramKO = 'Param vAdC konkur'[Wartość Param vAdC konkur]
     VAR Result =
CALCULATE( [Liczba firm CD],
   FILTER(
       ADDCOLUMNS( VALUES(Adreal_Dzienne[Właściciel marki]),
               "vAdC wybrana Grupa", [vAdC new KO],
               "vAdC WP kol", [vAdC WP] ),
       [vAdC wybrana Grupa] >= paramKO && [vAdC WP kol] <= paramWP )
)

Return Result
 ....
where calculated 
[Liczba firm CD] = COUNTROWS(VALUES(Adreal_Dzienne[Właściciel marki] ) )
Adreal_Dzienne[Właściciel marki] is a column with name of the industries
 
[vAdC new KO] is a measure calculating SUM of some data
[vAdC WP] is another measure also calculating SUM of some data

I have created two parameters and I want my measure to calculate only number of firms that are within this parameters:
FILTER(
       ADDCOLUMNS( VALUES(Adreal_Dzienne[Właściciel marki]),
               "vAdC wybrana Grupa", [vAdC new KO],
               "vAdC WP kol", [vAdC WP] ),
       [vAdC wybrana Grupa] >= paramKO && [vAdC WP kol] <= paramWP )
)
 
The number of firms that are in result of my measure is too big and it looks like it doesn't take in calculation this part: && [vAdC WP kol] <= paramWP, but maybe the measure isn't written correctly at all.
I have checked and when the Result was only VARs: paramWP i paramKO the values are just like I have selected. Maybe I wrongly write the sum of two conditions and it should be created differently not like this: [vAdC wybrana Grupa] >= paramKO && [vAdC WP kol] <= paramWP?
Or two parameters as conditions are not possible to use?

Maybe someone have an idea and will find a way to help me 🙂
 
bestregards
Andrzej
 
 
3 REPLIES 3
jgeddes
Super User
Super User

If you change your VAR Result to 

VAR Result =
COUNTROWS(
FILTER(
SUMMARIZE(
Adreal_Dzienne,
Adreal_Dzienne[Właściciel marki]
"vAdC wybrana Grupa"[vAdC new KO],
 "AdC WP kol"[vAdC WP] 
),
[vAdC wybrana Grupa] >= paramKO && [vAdC WP kol] <= paramWP 
)
)

does that get you the result you are looking for?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Hey, thanks but unfortunatly it gives me the same result as in my solution 😞
it looks like it doesn't take the 

&& [vAdC WP kol] <= paramWP 
condition into calculation 😞

I will try to put it into SWICH ( TRUE () ) logic and then count rows of the result.

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.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors