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.
Hello,
I don't know how to resolve this problem.
Imagine I have a list of Zoos and animals living in it (list is thousands of rows long).
Animals | Id of Zoo |
Horse | 1 |
Elephant | 1 |
Horse | 1 |
Horse | 2 |
Chicken | 2 |
Giraffe | 2 |
Horse | 3 |
Elephant | 4 |
Horse | 5 |
Elephant | 5 |
Elephant | 6 |
I would like to create a histogram with every "kind" of zoo. In this example:
We have
1 zoo with chickens, horses and giraffes
2 zoos with horses and elephants
2 zoos with elephants
1 zoo with horses
I counted it now, but how to get it in PBI?
I don't care if in the first zoo there is more than one horse
Regards
Solved! Go to Solution.
Firstly create a calculate colunm to mark every row:
Flag = VAR Type1 = CALCULATE(DISTINCTCOUNT('Table'[Animals]), FILTER(ALLEXCEPT('Table', 'Table'[Id of Zoo]), 'Table'[Animals] in {"Chicken", "Horse", "Giraffe"})) = 3 VAR Type2 = CALCULATE(DISTINCTCOUNT('Table'[Animals]), FILTER(ALLEXCEPT('Table', 'Table'[Id of Zoo]), 'Table'[Animals] in {"Horse", "Elephant"})) = 2 VAR Type3 = CALCULATE(DISTINCTCOUNT('Table'[Animals]), FILTER(ALLEXCEPT('Table', 'Table'[Id of Zoo]), 'Table'[Animals] in {"Elephant"})) = 1 VAR Type4 = CALCULATE(DISTINCTCOUNT('Table'[Animals]), FILTER(ALLEXCEPT('Table', 'Table'[Id of Zoo]), 'Table'[Animals] in {"Horse"})) = 1 RETURN SWITCH(TRUE(), Type1, "zoo with chickens, horses and giraffes", Type2, "zoos with horses and elephants", Type3, "zoos with elephants", Type4, "zoo with horses")
Then drag Flag and Id or Zoo to the stack column chart like below:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Firstly create a calculate colunm to mark every row:
Flag = VAR Type1 = CALCULATE(DISTINCTCOUNT('Table'[Animals]), FILTER(ALLEXCEPT('Table', 'Table'[Id of Zoo]), 'Table'[Animals] in {"Chicken", "Horse", "Giraffe"})) = 3 VAR Type2 = CALCULATE(DISTINCTCOUNT('Table'[Animals]), FILTER(ALLEXCEPT('Table', 'Table'[Id of Zoo]), 'Table'[Animals] in {"Horse", "Elephant"})) = 2 VAR Type3 = CALCULATE(DISTINCTCOUNT('Table'[Animals]), FILTER(ALLEXCEPT('Table', 'Table'[Id of Zoo]), 'Table'[Animals] in {"Elephant"})) = 1 VAR Type4 = CALCULATE(DISTINCTCOUNT('Table'[Animals]), FILTER(ALLEXCEPT('Table', 'Table'[Id of Zoo]), 'Table'[Animals] in {"Horse"})) = 1 RETURN SWITCH(TRUE(), Type1, "zoo with chickens, horses and giraffes", Type2, "zoos with horses and elephants", Type3, "zoos with elephants", Type4, "zoo with horses")
Then drag Flag and Id or Zoo to the stack column chart like below:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
108 | |
88 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |