cancel
Showing results 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

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 Result =
CALCULATE( [Liczba firm CD],
FILTER(
[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(
[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
Super User

If you change your VAR Result to

VAR Result =
COUNTROWS(
FILTER(
SUMMARIZE(
),
)
)

does that get you the result you are looking for?

Proud to be a Super User!

Frequent Visitor

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

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

Announcements

#### 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 Monthly Update - June 2024

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

#### 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
Top Kudoed Authors