Forum Discussion
Creating histogram using measure and dimension from data warehouse
- Anonymous1 year ago
Thanks for the reply from Poojara_D12 and Fowmy , please allow me to provide another insight:
Hi, Anonymous
Have the answers from Poojara_D12 and Fowmy resolved your issue? If so, please mark their responses as the solution. This will help others with similar questions find the answers more quickly.
Regarding your question, I have also created the following example:
1.Firstly, here is my sample data:
Bins = DATATABLE( "Bin", INTEGER, { {0}, {10}, {20}, {30}, {40}, {50}, {60}, {70}, {80}, {90}, {100} } )2.Secondly, I have created the following calculation table:
3.Next, I have created the following measures:
Frequency = COUNTROWS( FILTER( TestData, TestData[Value] >=MAX('Bins'[Bin])&& TestData[Value] < MAX('Bins'[Bin]) + 10 ) )4.Here's my final result, which I hope meets your requirements.
Please find the attached pbix relevant to the case.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
If you could add calcualted column to your table with the following formula and visualize your histogram, it would work too. This would be static though.
Bin =
SWITCH(
TRUE(),
[Value] >= 0 && [Value] <= 10, "0-10",
[Value] >= 11 && [Value] <= 20, "11-20",
[Value] >= 21 && [Value] <= 30, "21-30",
[Value] >= 31 && [Value] <= 40, "31-40",
"Other"
)
The other option is to have disconnected table and do it with a measure as.