Solved: Why Customer Id = 20 But Report shown 1 ?

Paulyeo11 · ‎10-07-2020

Hi All

My raw data , Customer Id = 20

But at report section , it display 1 why ?

MattAllington · ‎10-07-2020

My guess is it is showing count of cust id. Click the cust id in the values section on the right and change it to "do not summarize"

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Fowmy · ‎10-07-2020

@Paulyeo11

As @MattAllington , it could aggregation,

Right-click the Customer ID field on the Visualization Pane and change to Don' t summarize

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

Did I answer your question? Mark my post as a solution! and hit thumbs up

MattAllington · ‎10-07-2020

My guess is it is showing count of cust id. Click the cust id in the values section on the right and change it to "do not summarize"

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Why Customer Id = 20 But Report shown 1 ?