Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi guys
As a power bi newbie I have only attained a basic level of DAX and have hit a brick wall.
I am trying to validate energy measurements and the idea is to have a filter for all my visuals that filters on wheter there are 365 measurements over 1 year per site.
My dataset is like: Siteno, Date, Kwh
I can create a measure that can be fileted in a table visual - Count(Kwh) And filter = 365 in the visual, but I can not create a calculated table that gives me the possibility to create a filter visual?
Help will be much appriciated.
Solved! Go to Solution.
Hi @ragoe ,
Please try the DAX below and create the calculated column.
no.day = CALCULATE(COUNT('kwh 2018'[Dato]),ALLEXCEPT('kwh 2018','kwh 2018'[Dato]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not clear. Typically when you have the filter in calculate, it should filter your data in the visualization
Can you share sample data and sample output.
Hi
I will try to clear up.
Sample:
My measure is
Hi @ragoe ,
Please try the DAX below and create the calculated column.
no.day = CALCULATE(COUNT('kwh 2018'[Dato]),ALLEXCEPT('kwh 2018','kwh 2018'[Dato]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ragoe
If you meant Slicers then measures can't be used in Slicers. What you can try to do is a Calculated Column using 'COUNT('kwh 2018'[Dato])' and use in Slicer
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.
Hi AnkitBI
Yes of course, I mean slicer!
The problem is that if I do the calculated column I only get one option in the slicer? The total count of "Kwh".?
Hi @ragoe
Your requirement is not clear. Can you share some example of what are you trying to achieve and may be some better sample data.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |