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.
I have a slicer in PowerBI which I can select multiple months.
I added a Card in PowerBI with the "Month" selected and choose (Count Distinct). When I select multiple months in the slicer, PowerBI returns the exact count of months that I selected. If I choose August, September, October, the count is "3" just as expected.
I need to create a Column that multiplies "130 * DISTINCTCOUNT(ImportCubicPM[Month]"
test = CALCULATE(130 * ( DISTINCTCOUNT(ImportCubicPM[Month])))
If 2 months are selected by the slicer then the total should be 260.
The code above is not calculating properly. The numbers are off a little bit.
I am not sure if I should be using DISTINCTCOUNT
Any help would be greatly appreciated.
Thanks, Mike
Solved! Go to Solution.
Hi,
What result do you get with this?
=130*DISTINCTCOUNT(ImportCubicPM[Month])
@morther wrote:
I have a slicer in PowerBI which I can select multiple months.
I added a Card in PowerBI with the "Month" selected and choose (Count Distinct). When I select multiple months in the slicer, PowerBI returns the exact count of months that I selected. If I choose August, September, October, the count is "3" just as expected.
I need to create a Column that multiplies "130 * DISTINCTCOUNT(ImportCubicPM[Month]"
test = CALCULATE(130 * ( DISTINCTCOUNT(ImportCubicPM[Month])))
If 2 months are selected by the slicer then the total should be 260.
The code above is not calculating properly. The numbers are off a little bit.
I am not sure if I should be using DISTINCTCOUNT
Any help would be greatly appreciated.
Thanks, Mike
The DAX measure shall work If it is a measure. If you actually created a "Column" in your case, try to create a measure instead. Otherwise, for further suggestion, please post more sample data of your case. Or even better you can upload the pbix file to Onedrive/Google drive and share the link.
@morther wrote:
I have a slicer in PowerBI which I can select multiple months.
I added a Card in PowerBI with the "Month" selected and choose (Count Distinct). When I select multiple months in the slicer, PowerBI returns the exact count of months that I selected. If I choose August, September, October, the count is "3" just as expected.
I need to create a Column that multiplies "130 * DISTINCTCOUNT(ImportCubicPM[Month]"
test = CALCULATE(130 * ( DISTINCTCOUNT(ImportCubicPM[Month])))
If 2 months are selected by the slicer then the total should be 260.
The code above is not calculating properly. The numbers are off a little bit.
I am not sure if I should be using DISTINCTCOUNT
Any help would be greatly appreciated.
Thanks, Mike
The DAX measure shall work If it is a measure. If you actually created a "Column" in your case, try to create a measure instead. Otherwise, for further suggestion, please post more sample data of your case. Or even better you can upload the pbix file to Onedrive/Google drive and share the link.
Oh my goodness, I thought I had tried that yesterday but could not get it to accept the query as a measure.
This worked as a measure. Thank you so much.
Measure = 130*DISTINCTCOUNT(ImportCubicPM[Month])
Hi @morther,
I do not know whom you are replying to but that is exactly what my suggestion was.
Hi,
What result do you get with this?
=130*DISTINCTCOUNT(ImportCubicPM[Month])
Oh my goodness, that was my bad. This was exactly the answer.
Measure = 130*DISTINCTCOUNT(ImportCubicPM[Month])
I was doing this as a column, but when I changed it to a measure it worked as expected.
I am sorry for not giving credit where credit was due.
Mike
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |