Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

I want to display,number of customers for each month with the measure

m-mark = 

IF([sumlast3months]=3;"Gold";
IF([sumlast3months]=2;"Silver";
IF([sumlast3months]=1;"Bronze"; 

How can I find new customers in each month? 

1 Answer

0 votes
by (22.5k points)
edited by

By using the following measure:

Total by Segment = 
IF(
    ISFILTERED(CustomerSegments[Segment]),
    CALCULATE(
        [Total],
        FILTER(
            Customers,
            CALCULATE([Total Last 3 Months]) = SELECTEDVALUE(CustomerSegments[TotalLast3Months])
        )
    ),
    [Total]
)

You will get the result:

output

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification       

Learn Power BI Course from this video : 

:

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Dec 27, 2020 in BI by Chris (11.1k points)
0 votes
1 answer

Browse Categories

...